Example
//create a new ExcelPackage
using (ExcelPackage excelPackage = new ExcelPackage())
{
//create a datatable
DataTable dataTable = new DataTable();
//add three colums to the datatable
dataTable.Columns.Add("ID", typeof(int));
dataTable.Columns.Add("Type", typeof(string));
dataTable.Columns.Add("Name", typeof(string));
//add some rows
dataTable.Rows.Add(0, "Country", "Netherlands");
dataTable.Rows.Add(1, "Country", "Japan");
dataTable.Rows.Add(2, "Country", "America");
dataTable.Rows.Add(3, "State", "Gelderland");
dataTable.Rows.Add(4, "State", "Texas");
dataTable.Rows.Add(5, "State", "Echizen");
dataTable.Rows.Add(6, "City", "Amsterdam");
dataTable.Rows.Add(7, "City", "Tokyo");
dataTable.Rows.Add(8, "City", "New York");
//create a WorkSheet
ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet 1");
//add all the content from the DataTable, starting at cell A1
worksheet.Cells["A1"].LoadFromDataTable(dataTable, true);
}
