openpyxl修改excel出错

Question

Traceback (most recent call last):
File "D:\project\op.py", line 8, in
wb.save('e:/2.xlsx')
File "D:\python\lib\site-packages\openpyxl\workbook\workbook.py", line 396, in save
save_workbook(self, filename)
File "D:\python\lib\site-packages\openpyxl\writer\excel.py", line 294, in save_workbook
writer.save()
File "D:\python\lib\site-packages\openpyxl\writer\excel.py", line 276, in save
self.write_data()
File "D:\python\lib\site-packages\openpyxl\writer\excel.py", line 76, in write_data
self._write_worksheets()
File "D:\python\lib\site-packages\openpyxl\writer\excel.py", line 226, in _write_worksheets
self._write_comment(ws)
File "D:\python\lib\site-packages\openpyxl\writer\excel.py", line 180, in _write_comment
vml = fromstring(self.workbook.vba_archive.read(ws.legacy_drawing))
AttributeError: 'NoneType' object has no attribute 'read'

Answer 1

不知道你这个问题是否已经解决, 如果还没有解决的话:

• 你可以看下这个问题的回答https://ask.csdn.net/questions/7430289
• 你也可以参考下这篇文章：openpyxl实现excel自适应列宽

如果你已经解决了该问题, 非常希望你能够分享一下解决方案, 以帮助更多的人 ^-^