public void ListPropertiesTest()
{
var propertLister = new PropertyLister <Subscriber>();
propertLister.Load();
var list = propertLister.Properties.Select(p => p.Name).ToList();
Assert.Contains("Id", list);
Assert.Contains("Firstname", list);
Assert.Contains("Lastname", list);
Assert.Contains("Email", list);
Assert.Contains("Mobile", list);
}
public void ShouldWritePropertiesToFirstRow()
{
var list = new PropertyLister <Subscriber>();
list.Load();
var writer = new ExcelHeaderWriter <Subscriber>(list);
using (var workBook = new XLWorkbook())
{
var worksheet = workBook.AddWorksheet("test");
writer.WriteHeader(worksheet);
var writtenValue = (string)workBook.Worksheet("test").Cell("A1").Value;
Assert.AreEqual(writtenValue, "id");
}
}
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");
}
}
