Formatted workbook doesn't load
Created originally on Bitbucket by hynso (Nicolas May)
Hi there,
When I try to load a workbook with formatting that is generated by a database, I get the following error:
Traceback (most recent call last): File "xlsxParser.py", line 5, in wb = load_workbook('/path/to/spreadsheets/foo.xlsx') File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/openpyxl/reader/excel.py", line 202, in load_workbook parsed_styles = read_style_table(archive) File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/openpyxl/reader/style.py", line 181, in read_style_table p.parse() File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/openpyxl/reader/style.py", line 53, in parse self.parse_named_styles() File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/openpyxl/reader/style.py", line 109, in parse_named_styles names = self._parse_style_names() File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/openpyxl/reader/style.py", line 128, in _parse_style_names for _name in node: TypeError: 'NoneType' object is not iterable
But, if I clear the formatting of the .xlsx doc in Excel, I have no problems loading the workbook. Is this a known bug? I searched the issues, but couldn't find anything similar.
Ideally, I'd like to be able to use openpyxl without having to first use Excel to clear the formatting.
Thanks.
Attachments: Sample_export.xlsx