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