关键字
Expected BOF record、raise XLRDError、found b’# Filena’
异常描述
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
>>> book = xlrd.open_workbook(r'E:\python\learn\lean001.py',formatting_info=True ) Traceback (most recent call last): File "<stdin>", line 1, in <module> File "E:\python\python\lib\site-packages\xlrd\__init__.py", line 441, in open_ workbook ragged_rows=ragged_rows, File "E:\python\python\lib\site-packages\xlrd\book.py", line 91, in open_workb ook_xls biff_version = bk.getbof(XL_WORKBOOK_GLOBALS) File "E:\python\python\lib\site-packages\xlrd\book.py", line 1230, in getbof bof_error('Expected BOF record; found %r' % self.mem[savpos:savpos+8]) File "E:\python\python\lib\site-packages\xlrd\book.py", line 1224, in bof_erro r raise XLRDError('Unsupported format, or corrupt file: ' + msg) xlrd.biffh.XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b'# Filena' |
解决办法
此异常是Excel处理过程中出现的,出现此问题可能的原因
- 编码问题
- 文件不支持
1 2 |
>>> book = xlrd.open_workbook(r'E:\python\learn\demo.xls',formatting_info=True,e ncoding_override="utf-8") |
xlrd只支持‘xls’文件。不支持office2007
未经允许不得转载:Python在线学习 » Python异常-Expected BOF record