static void buildAdvance(List <SampleData> data, string fileName)
{
using (var stream = new FileStream(fileName, FileMode.OpenOrCreate, FileAccess.Write))
{
SimplyExcelWriter.Write(stream, data, options =>
{
options.ColumnMapBuilder = map =>
{
map.For(c => c.FirstName, 1, "First name")
.SetHeaderBackground(Color.Red)
.SetCellFormat("0")
.SetHeaderTextColor(Color.White);
map.For(c => c.LastName, 2);
map.For(c => c.DateOfBirth.Year, 3, "Year of");
map.For(c => c.DateOfBirth.Month, 4);
map.For(c => c.DateOfBirth.Day, 5);
map.For(c => c.DOB, 6, "Calc DOB")
.SetCellBackground(Color.Green)
.SetCellTextColor(Color.White)
.SetHeaderBackground(Color.Green)
.SetHeaderTextColor(Color.White)
.SetCellFormat("m/d/yyyy");
};
});
}
}
static void buildSimple(List <SampleData> data, string fileName)
{
using (var stream = new FileStream(fileName, FileMode.OpenOrCreate, FileAccess.Write))
{
SimplyExcelWriter.Write(stream, data);
}
}
