Skip to content

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);

Dim list = New List(Of Object()) From {
    New Object() {1, 2, 3},
    New Object() {4, 5, 6},
    New Object() {7, 8, 9}
}
Using package As New ExcelPackage()
    Dim sheet = package.Workbook.Worksheets.Add("Sheet 1")
    Dim importedRange = sheet.Cells("A1").LoadFromArrays(list)
End Using

InsertCols1

Transpose

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

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

sheet.Cells("A1").LoadFromArraysTransposed(list)

See also