it takes for ever to get sheets

[rafalkrupinski]

I'm opening a ods file with multiple sheets (books) but since adding odsr plugin, it takes very long time, I'm killing it after 5 minutes. No data is ever returned.

I'm suspecting that this line is the problem, trying to go thru ll tables in the file

pyexcel-odsr/pyexcel_odsr/messyods.py

Line 36 in 1fd4f27

rb".*?(<table:table.*?<\/.*?:table>).*?", re.MULTILINE

[chfw]

Does pyexcel-ods(3) do a better job?

[rafalkrupinski]

ods3 - not much, it works for a couple of files but leaks memory and gets killed by OOM killer

[rafalkrupinski]

A regex is used for this to avoid having to:

  1. load large the entire file into memory, or

🤔