public void ExcelTypeConfigurationTest() { ExcelTypeConfiguration c0 = new ExcelTypeConfiguration(); ExcelTypeConfiguration c1 = new ExcelTypeConfiguration(HeaderCollection.Create(new Header("h1", 1))); ExcelTypeConfiguration c2 = new ExcelTypeConfiguration("dd/MM/yyyy"); ExcelTypeConfiguration c3 = new ExcelTypeConfiguration(HeaderCollection.Create(new Header("h1", 1)), "dd/MM/yyyy"); Assert.AreEqual(c0.DateFormat, "yyyy-MM-dd"); Assert.AreEqual(c1.DateFormat, "yyyy-MM-dd"); Assert.AreEqual(c2.DateFormat, "dd/MM/yyyy"); Assert.AreEqual(c3.DateFormat, "dd/MM/yyyy"); Assert.AreEqual(c0.DecimalFormat, "#,##0.00"); Assert.AreEqual(c1.DecimalFormat, "#,##0.00"); Assert.AreEqual(c2.DecimalFormat, "#,##0.00"); Assert.AreEqual(c3.DecimalFormat, "#,##0.00"); Assert.IsNull(c0.Headers); Assert.IsNotNull(c1.Headers); Assert.IsNull(c2.Headers); Assert.IsNotNull(c3.Headers); Assert.IsTrue(c1.Headers.Count == 1); Assert.IsTrue(c3.Headers.Count == 1); }
public void TestListToExcelConfiguration() { IList <People> peoples = new List <People> { new People { Id = 1, Name = "Name 1" }, new People { Id = 2, Name = "Name 2" } }; ExcelTypeConfiguration config = new ExcelTypeConfiguration(); byte[] peopleExcelArrayBytes = peoples.ToExcelByte(); bool save = peoples.ToExcelSaveAs($"./{System.Guid.NewGuid().ToString()}.xlsx", config); Assert.IsInstanceOfType(peopleExcelArrayBytes.GetType(), typeof(byte[]).GetType()); Assert.IsTrue(save); }