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