Openpyxl在使用迭代器时导致编码错误

2024-04-20 09:46:46 发布

您现在位置:Python中文网/ 问答频道 /正文

我写了一个脚本来解析excel文档。我将脚本传输到另一台计算机,现在出现以下错误:

Traceback (most recent call last):
File "excelReader.py", line 50, in <module>
wb = load_workbook(doc, use_iterators = True)
File "build/bdist.macosx-10.7-intel/egg/openpyxl/reader/excel.py", line 118, in load_workbook
File "build/bdist.macosx-10.7-intel/egg/openpyxl/reader/excel.py", line 69, in repair_central_directory
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/encodings/utf_8.py", line 16, in decode
return codecs.utf_8_decode(input, errors, True)
UnicodeDecodeError: 'utf8' codec can't decode byte 0xf8 in position 169: invalid start byte

这在编写它的机器上运行得很好,当我删除use_iterators = True时,该脚本运行良好。在

编辑:我把文件从桌面移到文档中,暂时解决了这个问题


Tags: in文档pybuild脚本trueuseline