public void WriteTest()
{
IWorkbook workbook = new HSSFWorkbook();
var worksheet = workbook.CreateSheet("sample");
var rowWriter = new ExcelRowWriter(worksheet, 2, 4);
rowWriter.Write(new object[] { 1, 2, 3, 4 });
rowWriter.Write(new object[] { "1", "2", "3", "4" });
rowWriter.Write(new object[] { new DateTime(2016, 1, 1), new DateTime(2016, 1, 1, 1, 1, 1) });
rowWriter.Write(new object[] { true, "", false });
rowWriter.Write(new object[] { new Model() });
using (var stream = new FileStream("files/WriterTest.xls", FileMode.Create, FileAccess.Write))
workbook.Write(stream);
}
public void ShouldWriteOneRowToWorkBook()
{
var list = new PropertyLister <Subscriber>();
list.Load();
var writer = new ExcelRowWriter <Subscriber>(list);
using (var workBook = new XLWorkbook())
{
var worksheet = workBook.AddWorksheet("test");
writer.WriteRow(worksheet, new Subscriber {
Id = "1",
Email = "Hej"
}, 1);
var writtenValue = (string)workBook.Worksheet("test").Cell("A1").Value;
Assert.IsTrue(writtenValue == "1");
}
}
