ArrayToExcel

Create Excel from Array

Example 1: Create with default settings

using ArrayToExcel;

var items = Enumerable.Range(1, 10).Select(x => new
{
    Prop1 = $"Text #{x}",
    Prop2 = x * 1000,
    Prop3 = DateTime.Now.AddDays(-x),
});

var excel = items.ToExcel();

Result: example1.xlsx

Example 2: Rename sheet and columns

var excel = items.ToExcel(schema => schema
    .SheetName("Example name")
    .ColumnName(m => m.Name.Replace("Prop", "Column #")));

Result: example2.xlsx

Example 3: Sort columns

var excel = items.ToExcel(schema => schema
    .ColumnSort(m => m.Name, desc: true));

Result: example3.xlsx

Example 4: Custom column's mapping

var excel = items.ToExcel(schema => schema
    .AddColumn("MyColumnName#1", x => x.Prop1)
    .AddColumn("MyColumnName#2", x => $"test:{x.Prop2}")
    .AddColumn("MyColumnName#3", x => x.Prop3));

Result: example4.xlsx

Example 5: Additional sheets

var excel = items.ToExcel(schema => schema
    .SheetName("Main")
    .AddSheet(extraItems));

Result: example5.xlsx

Example.ConsoleApp