本文介绍了python xlrd 格式不受支持,或文件损坏.的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的代码:
import xlrd
wb = xlrd.open_workbook("Z:\Data\Locates\3.8 locates.xls")
sh = wb.sheet_by_index(0)
print sh.cell(0,0).value
错误:
Traceback (most recent call last):
File "Z:Wilson radedStockStatus.py", line 18, in <module>
wb = xlrd.open_workbook("Z:\Data\Locates\3.8 locates.xls")
File "C:Python27libsite-packagesxlrd\__init__.py", line 429, in open_workbook
biff_version = bk.getbof(XL_WORKBOOK_GLOBALS)
File "C:Python27libsite-packagesxlrd\__init__.py", line 1545, in getbof
bof_error('Expected BOF record; found %r' % self.mem[savpos:savpos+8])
File "C:Python27libsite-packagesxlrd\__init__.py", line 1539, in bof_error
raise XLRDError('Unsupported format, or corrupt file: ' + msg)
xlrd.biffh.XLRDError: Unsupported format, or corrupt file: Expected BOF record;
found '<table r'"
文件似乎没有损坏或格式不同.任何有助于找到问题根源的东西都会很棒.
The file doesn't seem to be corrupted or of a different format.Anything to help find the source of the issue would be great.
推荐答案
你说:
文件似乎没有损坏或格式不同.
然而,正如错误消息所说,文件的前 8 个字节是 However as the error message says, the first 8 bytes of the file are 这篇关于python xlrd 格式不受支持,或文件损坏.的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!'
... 这绝对不是 Excel
.xls
格式.使用不会注意到(不正确).xls
扩展名的文本编辑器(例如记事本)打开它,然后自己查看.'<table r'
... that is definitely not Excel .xls
format. Open it with a text editor (e.g. Notepad) that won't take any notice of the (incorrect) .xls
extension and see for yourself.05-19 07:37