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、问题原因
有一段这样的话:
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文件