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
Speed of reading XLSX files
Re: Speed of reading XLSX files
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.
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.
Lars Arvidsson, Axolot Data
Re: Speed of reading XLSX files
Hello,
version 4.00.53 is not faster.
Reading xlsx (68MB size) gives the message:
Out of memory while expanding memory stream.
version 4.00.53 is not faster.
Reading xlsx (68MB size) gives the message:
Out of memory while expanding memory stream.