xlrd错误消息

Question

我尝试使用xlrd来操作一个.xls文件，如下所示：

>>> import xlrd
>>> workbook = xlrd.open_workbook('6h.xls')

我得到了：

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>

  File "/home/wayne-szalinsky/virt_env/virt_env/virt2/local/lib/python2.7/site-packages/xlrd/__init__.py", line 435, in open_workbook
    ragged_rows=ragged_rows,

  File "/home/wayne-szalinsky/virt_env/virt_env/virt2/local/lib/python2.7/site-packages/xlrd/book.py", line 91, in open_workbook_xls
    biff_version = bk.getbof(XL_WORKBOOK_GLOBALS)

  File "/home/wayne-szalinsky/virt_env/virt_env/virt2/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/wayne-szalinsky/virt_env/virt_env/virt2/local/lib/python2.7/site-packages/xlrd/book.py", line 1224, in bof_error
    raise XLRDError('Unsupported format, or corrupt file: ' + msg)
xlrd.biffh.XLRDError: Unsupported format, or corrupt file: Expected BOF record; found '<?xml ve'

Answer 1

您的文件显然是文件扩展名.xls不正确的XML文件。如果要将其作为Excel文件打开，则必须首先将其另存为Excel文件，而不仅仅是命名为Excel文件。

您可以在文本编辑器中打开它，观察XML文档是如何布局的，然后编写代码来解析XML，而不是使用xlrd。