所以如果我有这个代码:
from openpyxl import Workbook
wb = Workbook()
ws = wb.create_sheet(0)
ws.title = 'Title'
ws.cell('A3').value = 8
wb.save('temp.xlsx')
我得到错误:
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/local/lib/python3.3/dist-packages/openpyxl/workbook.py", line 233, in save
save_workbook(self, filename)
File "/usr/local/lib/python3.3/dist-packages/openpyxl/writer/excel.py", line 159, in save_workbook
writer.save(filename)
File "/usr/local/lib/python3.3/dist-packages/openpyxl/writer/excel.py", line 142, in save
self.write_data(archive)
File "/usr/local/lib/python3.3/dist-packages/openpyxl/writer/excel.py", line 83, in write_data
self._write_worksheets(archive, shared_string_table, self.style_writer)
File "/usr/local/lib/python3.3/dist-packages/openpyxl/writer/excel.py", line 104, in _write_worksheets
style_writer.get_style_by_hash()))
File "/usr/local/lib/python3.3/dist-packages/openpyxl/writer/worksheet.py", line 96, in write_worksheet
for range_string, rules in worksheet.conditional_formatting.cf_rules.iteritems():
AttributeError: 'dict' object has no attribute 'iteritems'
我甚至连最简单的电子表格都无法工作。它们都显示了这个错误。
openpyxl 1.8.0/python 3.3.2
我做错了什么?
更新:python脚本适用于python 3,但如果我用python 2.7.5运行它,脚本就可以工作。
有人能告诉我为什么吗?
这绝对不可能发生在2014年1月才发布的openpyxl 1.8中。最初的错误在1.7中得到修复,它通过了Python 2.5、2.6、2.7、3.2和3.3 的所有测试