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);
}
