public void ExportWithAttributesAndSomeSheetsNames()
{
IList <DummyPersonWithAttributes> dummyPeopleSheet1 = new List <DummyPersonWithAttributes>();
IList <DummyPersonWithAttributes> dummyPeopleSheet2 = new List <DummyPersonWithAttributes>();
IList <DummyPersonWithAttributes> dummyPeopleSheet3 = new List <DummyPersonWithAttributes>();
for (int index = 0; index < 30; index++)
{
dummyPeopleSheet1.Add(DummyFactory.CreateDummyPersonWithAttributes());
}
for (int index = 0; index < 50; index++)
{
dummyPeopleSheet2.Add(DummyFactory.CreateDummyPersonWithAttributes());
}
for (int index = 0; index < 25; index++)
{
dummyPeopleSheet3.Add(DummyFactory.CreateDummyPersonWithAttributes());
}
IExcelExportEngine engine = new ExcelExportEngine();
engine.AsExcel().SetFormat(ExcelVersion.XLS);
engine.AsExcel().AddData(dummyPeopleSheet1, "Sheet Number 1");
engine.AsExcel().AddData(dummyPeopleSheet2, "Another Sheet");
engine.AsExcel().AddData(dummyPeopleSheet3, "Custom Name");
var fileName = Guid.NewGuid().ToString() + "-with-attributes-some-sheets.xls";
var filePath = PathConfig.BASE_PATH + fileName;
engine.Export(filePath);
}
public void ExportWithAttributes()
{
IList <DummyPersonWithAttributes> dummyPeople = new List <DummyPersonWithAttributes>();
for (int index = 0; index < 30; index++)
{
dummyPeople.Add(DummyFactory.CreateDummyPersonWithAttributes());
}
IExportEngine engine = new ExcelExportEngine();
engine.AddData(dummyPeople);
var fileName = Guid.NewGuid().ToString() + "-with-attributes.xlsx";
var filePath = PathConfig.BASE_PATH + fileName;
engine.Export(filePath);
}
public void ExportWithAttributesAndRuntimeRename()
{
IList <DummyPersonWithAttributes> dummyPeople = new List <DummyPersonWithAttributes>();
for (int index = 0; index < 30; index++)
{
dummyPeople.Add(DummyFactory.CreateDummyPersonWithAttributes());
}
IExportEngine engine = new ExcelExportEngine();
var key = engine.AddData(dummyPeople);
engine.AddColumnsNames <DummyPersonWithAttributes>(key, x => x.Name, "this is a new name LOL!");
var fileName = Guid.NewGuid().ToString() + "-with-runtime-rename.xlsx";
var filePath = PathConfig.BASE_PATH + fileName;
engine.Export(filePath);
}