Speed of reading XLSX files
Posted: Thu May 12, 2011 12:18 pm
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
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