Speed of reading XLSX files

[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

[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.

[wmikki]

Hello,
version 4.00.53 is not faster.
Reading xlsx (68MB size) gives the message:
Out of memory while expanding memory stream.