Page 1 of 1

Speed of reading XLSX files

Posted: Thu May 12, 2011 12:18 pm
by joseffric
Hallo

Is it some hope that reading XLSX files will be quicker ? I've tried simple code for creating XLSX with 75000 lines 4 columns. Creating took less than 2 second and writing into XLSX less than 10 seconds. It is good and there is no problem.

Problem is when I try to read created file. Reading take more than 120 seconds and I think that this should be optimalized. Excel reads the same file in about 10 seconds, so I can accept double time but no 12 times longer.

Thanks

Josef

Re: Speed of reading XLSX files

Posted: Mon May 16, 2011 5:30 pm
by larsa
Hello

We are working on an update of the component that will address the long read time and other issues with XLSX file. Initial tests shows reading times about the same as excel.

Re: Speed of reading XLSX files

Posted: Wed Aug 03, 2011 4:01 pm
by wmikki
Hello,
version 4.00.53 is not faster.
Reading xlsx (68MB size) gives the message:
Out of memory while expanding memory stream.