KeyError for styles when writing a worksheet with no style settings
Created originally on Bitbucket by jeffwong (Jeff Wong)
I wrote a bunch of cells to a worksheet but the style writing code doesn't gracefully write a style table if I have never accessed any style information in any cell on a sheet.
Workaround is to access cell.style for any style.
{{{ Traceback (most recent call last): File "sgAutoAnalyze.py", line 219, in wb.save('test.xlsx') File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/openpyxl/workbook.py", line 186, in save save_workbook(self, filename) File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/openpyxl/writer/excel.py", line 141, in save_workbook writer.save(filename) File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/openpyxl/writer/excel.py", line 124, in save self.write_data(archive) File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/openpyxl/writer/excel.py", line 70, in write_data self._write_worksheets(archive, shared_string_table, self.style_writer) File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/openpyxl/writer/excel.py", line 91, in _write_worksheets style_writer.get_style_by_hash())) File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/openpyxl/writer/worksheet.py", line 59, in write_worksheet write_worksheet_data(doc, worksheet, string_table, style_table) File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/openpyxl/writer/worksheet.py", line 160, in write_worksheet_data hash(worksheet._styles[coordinate])] KeyError: 4070258 }}}