LoadFromArrays

The LoadFromArrays method provides an easy way of loading an IEnumerable<object[]> into a range on a worksheet.

Overview

var list = new List<object[]> {
    new object[] { 1, 2, 3 },
    new object[] { 4, 5, 6 },
    new object[] { 7, 8, 9 }
};
using var package = new ExcelPackage();
var sheet = package.Workbook.Worksheets.Add("Sheet 1");
var importedRange = sheet.Cells["A1"].LoadFromArrays(list);

Transpose

You can also load the data transposed from an array by using the LoadFromArraysTransposed method.

sheet.Cells["A1"].LoadFromArraysTransposed(list);

See also

• Import data