How to set cell values with an array of data in EPPlus?

Question

I've tried searching but I cannot seem to find a way to set a range of values using an array.

Do I have to use a double loop to do this? Is there no way to use a multidimensional array for it like in Google App Scripts? In particular, I am looking for similar functionality to https://developers.google.com/apps-script/class_range#setValues in EPPlus.

double loop is the best way on this. If you have to use this time and time, let's try to create a function to do it easier. — Han, Dec 17 '12 at 05:02

score 2 · Answer 1 · answered Feb 02 '15 at 13:54

2

Possibly of interest. I found ExcelRangeBase.LoadFromArrays and LoadFromCollection but the implementation uses a double loop...

answered Feb 02 '15 at 13:54

David Hollinshead

1,710
17
18

score 1 · Accepted Answer · answered Jan 12 '13 at 09:41

1

A double loop is the only way to go.

answered Jan 12 '13 at 09:41

Jack

5,680
10
49
74

How to set cell values with an array of data in EPPlus?

2 Answers2