Python读取excel报Unsupported format, or corrupt file: Expected BOF record; found b'<?xml ve'问题

1、代码

'''
Created on 2017年7月7日

@author: yuanchangyou
'''
# -*- coding: utf-8 -*- 
import  xdrlib ,sys
import xlrd

file = 'D://yuanchangyou//yuqing.xls'
try:
    data = xlrd.open_workbook(file,encoding_override='utf-8')
    return data
except Exception as e:
    print (str(e))empty

2、报错信息

Unsupported format, or corrupt file: Expected BOF record; found b'<?xml ve'

3、问题原因

参阅了网上资料： https://stackoverflow.com/questions/9623029/python-xlrd-unsupported-format-or-corrupt-file

有一段这样的话：

However as the error message says, the first 8 bytes of the file are '<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.

意思是说，这个文件不是个excel文件，虽然以.xls结尾，但是内部格式不对，不信你用文本编辑器打开看看，

结果我打开是这样的：

而正常的xls文件是这样的：

4、结论

文中提到  Could have been saved as XML Spreadsheet (*.xml) (not supported by xlrd)

是xlrd不支持这种方式的excel文件