Skip to content

load_workbook works very slow

Created originally on Bitbucket by Maya

I have a excel file (not very large, 600kb, but inside there is a lot of formated and merged cells).

I used to use openpyxl in version 2.5.12 and everything worked fine, load_workbook lasted 1s or less. But recently I updated openpyxl to 3.0.0 version and now it takes about 10 minutes to load the same workbook.

What can I do except back to 2.5.12 version?

Attachments: CAIQ_v3.1_Final.xlsx

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information