Crash while saving styles
Created originally on Bitbucket by kaywebber
Code: {{{ #!python import openpyxl import openpyxl.workbook import openpyxl.writer.excel
excel = openpyxl.workbook.Workbook() excel.properties.creator = 'Kay' excel.properties.title = 'Excel2007 demo'
excel.get_active_sheet().cell("A1").value = "Regular text test" excel.get_active_sheet().cell("A2").value = "www.example.com" #Styles generate exception excel.get_active_sheet().cell("A2").style.font.color = openpyxl.style.Color.BLUE
excel.get_active_sheet().column_dimensions["A"].width = 30 #Not working excel.get_active_sheet().row_dimensions[1].height = 10
writer = openpyxl.writer.excel.ExcelWriter(excel) writer.save("openpyxl.xlsx") }}}
Generates exception: {{{ Traceback (most recent call last): File "gen.py", line 40, in writer.save("openpyxl.xlsx") File "/home/black/openpyxl-excel2007/openpyxl/writer/excel.py", line 92, in save style_table = style_id_by_hash)) File "/home/black/openpyxl-excel2007/openpyxl/writer/worksheet.py", line 69, in write_worksheet write_worksheet_data(doc, worksheet, string_table, style_table) File "/home/black/openpyxl-excel2007/openpyxl/writer/worksheet.py", line 149, in write_worksheet_data attributes['s'] = '%d' % style_id_by_hash[worksheet._styles[coordinate].crc()] NameError: global name 'style_id_by_hash' is not defined }}}