I've a big xlsx file (30 Mb). Opening it will costs more than one minute (MS Excel takes more than that).
Is it possible to only get the first 20 lines of each worksheet in a fast way? I looked at the virtual mode demo, but wasn't able to decrease loading time significantly (just from 1:10 to 1:03) by altering read_Cells
Is it possible to load just one worksheet of a spreadsheet with the command xls.Open(FileName, Sheetname) or otherwise?
The trend
is that people are creating bigger and bigger files (especially when they found
the pivot option). This new virtual mode really speed up things for me. Also
thanks for the Performance.pdf, very interesting.