This project has moved. For the latest updates, please go here.

Setting range value in bulk with 2D object array

Jun 23, 2016 at 12:41 PM
I am using Microsoft.Office.Interop.Excel to copy a 2D object array to a predefined range in an excelsheet.

Here is the code:
Excel.Range r1 = (Excel.Range)xlWorkSheet.Cells[1, 1];
Excel.Range r2 = (Excel.Range)xlWorkSheet.Cells[50000, 4];
Excel.Range range = xlWorkSheet.get_Range(r1, r2);

object[,] myArray = new object[50000, 4];
//Data added to myArray. I have normally more that 50000 rows.
range.Value = myArray;

This gave me very good performance unlike other "LoadFrom.." methods of EPPlus.
Is there anyway to do this in EPPlus ?