ArrayToExcel

Create Excel from Array (List, DataTable, DataSet, ...)

Example 1: Create with default settings

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

Result: example1.xlsx

Example 2: Rename sheet and columns

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

Result: example2.xlsx

Example 3: Sort columns

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

Result: example3.xlsx

Example 4: Custom column's mapping

varexcel=items.ToExcel(schema =>schema.AddColumn("MyColumnName#1", x =>newCellHyperlink($"https://www.google.com/search?q={x.Prop1}",x.Prop1)).AddColumn("MyColumnName#2", x =>$"test:{x.Prop2}").AddColumn("MyColumnName#3", x =>x.Prop3));

Result: example4.xlsx

Example 5: Additional sheets

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

Result: example5.xlsx

Example 6: Create from DataSet

vardataSet=newDataSet();for(vari=1;i<=3;i++){vartable=newDataTable($"Table{i}");dataSet.Tables.Add(table);table.Columns.Add($"Column {i}-1",typeof(string));table.Columns.Add($"Column {i}-2",typeof(int));table.Columns.Add($"Column {i}-3",typeof(DateTime));for(varx=1;x<=10*i;x++)table.Rows.Add($"Text #{x}",x*1000,DateTime.Now.AddDays(-x));}varexcel=dataSet.ToExcel();

Result: example6.xlsx

Example.ConsoleApp