LoadFromDataTable

This method loads a System.Data.DataTable into a spreadshet.

Basic usage

A DataTable can be filled with data from various sources, often a database. In this simple example we will create it and fill it ourselves.

var table = new DataTable("Astronauts");
table.Columns.Add("Id", typeof(int));
table.Columns.Add("FirstName", typeof(string));
table.Columns.Add("LastName", typeof(string));
// add some data
table.Rows.Add(1, "Bob", "Behnken");
table.Rows.Add(2, "Doug", "Hurley");

//create a workbook with a spreadsheet and load the data table
using(var package = new ExcelPackage())
{
    var sheet = package.Workbook.Worksheets.Add("Astronauts");
    sheet.Cells["A1"].LoadFromDataTable(table);
}