xlrd读取xls XLRDError:不支持的格式或文件损坏:预期的BOF记录;找到了'\ r \ n< html>' [英] xlrd reading xls XLRDError: Unsupported format, or corrupt file: Expected BOF record; found '\r\n<html>'
本文介绍了xlrd读取xls XLRDError:不支持的格式或文件损坏:预期的BOF记录;找到了'\ r \ n< html>'的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
这是代码:
xls = open_workbook('data.xls')
作为回报:
File "/home/woles/P2/fin/fin/apps/data_container/importer.py", line 16, in import_data
xls = open_workbook('data.xlsx')
File "/home/woles/P2/fin/local/lib/python2.7/site-packages/xlrd/__init__.py", line 435, in open_workbook
ragged_rows=ragged_rows,
File "/home/woles/P2/fin/local/lib/python2.7/site-packages/xlrd/book.py", line 91, in open_workbook_xls
biff_version = bk.getbof(XL_WORKBOOK_GLOBALS)
File "/home/woles/P2/fin/local/lib/python2.7/site-packages/xlrd/book.py", line 1230, in getbof
bof_error('Expected BOF record; found %r' % self.mem[savpos:savpos+8])
File "/home/woles/P2/fin/local/lib/python2.7/site-packages/xlrd/book.py", line 1224, in bof_error
raise XLRDError('Unsupported format, or corrupt file: ' + msg)
XLRDError: Unsupported format, or corrupt file: Expected BOF record; found '\r\n<html>'
文件未损坏,我可以使用Excel,LibreOffice打开它.
The file is not damaged, I can open it with Excel, LibreOffice.
推荐答案
对于.xls
文件,您可以使用read_excel()
:
For .xls
files you can use read_excel()
:
df1= pd.read_excel("filename.xls")
The parameters header
and sep
may help you get rid of some errors (here you can find more info on the parameters). An example of its usage
df2= pd.read_excel("filename.xls", header = None, sep='delimiter')
注意,如果文件是.csv
,则会出现错误
Note that if the files are a .csv
you will get the error
XLRDError:不支持的格式或文件损坏:预期的BOF记录;
XLRDError: Unsupported format, or corrupt file: Expected BOF record;
要阅读.csv
,需要使用read_csv()
,就像这样
To read .csv
one needs to use read_csv()
, like this
df3= pd.read_csv("filename.csv")
这篇关于xlrd读取xls XLRDError:不支持的格式或文件损坏:预期的BOF记录;找到了'\ r \ n< html>'的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文