Formatted workbook doesn't load
*Created originally on Bitbucket by [hynso (Nicolas May)](https://bitbucket.org/%7B00948f24-53d9-4022-a51e-c4c3c8e76823%7D/)*
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 <module>
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](/uploads/f3016b5a3b29fe3f831bfc8c96a8bb3a/Sample_export.xlsx)
issue