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

Poor performance in the column direction

Oct 22, 2013 at 10:26 PM
Hi,

first thanks for developing such a great library, it looks really promising.
I've decided to give it a try but I have a really strange issue.

I'm trying to do the more basic operation: writing a matrix of numbers (int[,]) into an xlsx file :
using (ExcelPackage package = new ExcelPackage(new FileInfo(EEPlusFileName)))
{
    ExcelWorksheet sheet = package.Workbook.Worksheets.Add("data");

    sheet.Cells[1, 1, data.GetLength(0), data.GetLength(1)].Value = data;
}
I've tried with a 400x400 matrix and it takes more than 7s!
But with a 160000x1 matrix it takes 0.5s!

Is there any known issue with the columns?

I guess your implementation internally manages things in a row-first way explaining the difference between the two approach.

Any feedback and pointer would be greatly appreciated.

Thanks in advance.