python之xlrd 读取 xls XLRDError : Unsupported format, 或损坏的文件:预期的 BOF 记录；发现 '\r\nhtml>'

这是代码:

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打开它。

请您参考如下方法:

尝试用pandas打开:

import pandas as pd 
data=pd.read_html(filename.xls) 

或者尝试任何其他 html python 解析器。

这不是正确的 excel 文件，而是 excel 可读的 html。