Version 3.0.10 can open excel files that are "Read-only recomended"
This is my first time reporting an issue, so im sorry if im doing it wrong.
in Version 3.0.10 I can open all my files and get data (100 of files) but any upgrade after that will give me
"ValueError: Unable to read workbook: could not read worksheets from C:/py_excel/test.xlsm.
This is most probably because the workbook source files contain some invalid XML.
Please see the exception for more details."
downgrading back to 3.0.10 will make my scripts work again.
I have traced the problem to the prompt "The author would like you to open this as read-only. unless you need to make changes. open as read-only?"
this promt comes if you during save file in excel do this
- save as
- More Optionions
- Tools
- Geeneral options
- mark as "Read-only recommended"
we have this set on some templates that are use every week so people dont overwrite the template by mistake.
I dont know what make openpyxl change how it handle this in later verions, but it would be nice if you could make this work in your updates.
Thank you verry much for a great lib.