search

MichaelDaum / spreadsheet-parsexlsx

parse XLSX files
http://metacpan.org/release/Spreadsheet-ParseXLSX
1 stars 3 forks source link

Performance problem opening XLSX Version > 0.27 #11

Closed danisowa closed 6 months ago

danisowa commented 6 months ago

Hello,

opening a relatively huge XLSX file (30.000 rows with merged cells) takes really long to load

Version <= 0.27 takes 20 seconds. Version > 0.27 takes more than 7 minutes

Would be great if performance could be increased to reach level of 0.27 verion

MichaelDaum commented 6 months ago

I observed quite the opposite. Have you got a test file that shows these problems? Thanks.

danisowa commented 6 months ago

Tanks for your fast reply! I've prepared the file with "dummy data" and verified loading with 0.27 and > 0.27... behaviour as described

test_file.xlsx

MichaelDaum commented 6 months ago

Fixed in version 0.33

danisowa commented 6 months ago

verified and working as expected. Thank you very much for this quick fix!