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 ?
PS: my xlsx are simple tables