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

### Overview

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

```vbnet
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
```

## Transpose

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

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

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

### See also

- [Import data](<https://epplussoftware.com/docs/import-export-data/import/index.md>)