public void Constructor_WithValidWorksheet_SetsCurrentCellToTopLeft() { // Arrange var worksheet = ExcelTestBuilder.CreateExcelWorksheet(); // Act _sut = new ExcelSpreadsheetWriter(worksheet); // Assert _sut.CurrentPosition.X.Should().Be(1); _sut.CurrentPosition.Y.Should().Be(1); }
static void Main(string[] args) { using (var file = new FileStream("sample.csv", FileMode.Create)) using (var writer = new CsvSpreadsheetWriter(file)) PopulateData(writer); using (var file = new FileStream("sample.xml", FileMode.Create)) using (var writer = new XmlSpreadsheetWriter(file)) PopulateData(writer); using (var file = new FileStream("sample.xlsx", FileMode.Create)) using (var writer = new ExcelSpreadsheetWriter(file, System.IO.Compression.CompressionLevel.Optimal)) PopulateData(writer); }
public void Initialize() { _fixture = new Fixture(); _worksheet = ExcelTestBuilder.CreateExcelWorksheet(); _sut = new ExcelSpreadsheetWriter(_worksheet); }