Missing value in style_table on saving a worksheet
Created originally on Bitbucket by camolin3 (Carlos Molina)
Hi, I'm having a problem while editing a xlsx file.
This is what I've done:
#!python
from openpyxl import load_workbook
wb = load_workbook(filename = r'/home/carlos/Desktop/Original.xlsx')
ws = wb.active
c = ws['B1']
c.value = 'MES: Febrero'
wb.save('/home/carlos/Desktop/Original/Modified.xlsx')
And an error occurs:
#!bash
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/home/carlos/Code/ekono/venv/local/lib/python2.7/site-packages/openpyxl/workbook.py", line 265, in save
save_workbook(self, filename)
File "/home/carlos/Code/ekono/venv/local/lib/python2.7/site-packages/openpyxl/writer/excel.py", line 187, in save_workbook
writer.save(filename)
File "/home/carlos/Code/ekono/venv/local/lib/python2.7/site-packages/openpyxl/writer/excel.py", line 170, in save
self.write_data(archive)
File "/home/carlos/Code/ekono/venv/local/lib/python2.7/site-packages/openpyxl/writer/excel.py", line 98, in write_data
self._write_worksheets(archive, shared_string_table, self.style_writer)
File "/home/carlos/Code/ekono/venv/local/lib/python2.7/site-packages/openpyxl/writer/excel.py", line 128, in _write_worksheets
style_writer.get_style_by_hash()))
File "/home/carlos/Code/ekono/venv/local/lib/python2.7/site-packages/openpyxl/writer/worksheet.py", line 98, in write_worksheet
write_worksheet_cols(doc, worksheet, style_table)
File "/home/carlos/Code/ekono/venv/local/lib/python2.7/site-packages/openpyxl/writer/worksheet.py", line 209, in write_worksheet_cols
col_def['style'] = str(style_table[hash(columndimension.style_index)])
KeyError: 5795956877168828559
I'm not sure why this error occurs. It seems it tries to access a style that doesn't exist.
I have appended the file. I hope you can help me :)
Attachments: Original.xlsx