LoadFromDictionaries

This method loads data from a collection of IDictionary<string, object> or ExpandoObject (which implements the IDictionary<string, object> interface) into a spreadsheet.

The LoadFromDictionaries is available from version 5.2.1 and higher.

Basic usage

The main purpose of this method is to support IEnumerables of ExpandoObjects, so that it what we will use in these examples. But you can create your own dictionaries to load data.

First, let us create a list of System.Dynamic.ExpandoObject's:

dynamic o1 = new ExpandoObject();
o1.Id = 1;
o1.Name = "TestName 1";
dynamic o2 = new ExpandoObject();
o2.Id = 2;
o2.Name = "TestName 2";
var items = new List<ExpandoObject>()
{
    o1,
    o2
};

Now we can import these objects to a spreadsheet using the LoadFromDictionaries method.

using (var package = new ExcelPackage())
{
    var sheet = package.Workbook.Worksheets.Add("test");
    var r = sheet.Cells["A1"].LoadFromDictionaries(items);
}