Read very large xlsx

May 10, 2011 at 5:18 PM

Hello,

I need to read large xlsx, something like 50 columns per 60.000 rows and the operation it's very slow and memory consuming.

I simply loop rows and columns and I read a cell value at time :

object valore = currentWorksheet.Cells[i, col].Value;

There are a faster way to read  the entire row or direct way to read a range in a array ?

Thank you.

PS: my xlsx are simple tables

Coordinator
May 10, 2011 at 6:34 PM

Hi,

No, a worksheet in that size will consume a lot of memory. If you get out of memory things will go really slow, so have a look at the taskmanager when you read the package and make sure you still have physical memory left.

Jan