Skip to main content
 首页 » 编程设计

Python Xlrd读取excel文件报错

2025年05月04日15lyhabc

我一直在 Windows 上编写脚本,现在将平台更改为 Linux/Ubuntu 时遇到了一些问题。在下面的示例中,我只是尝试打印工作表名称,但收到了一些我以前从未见过的错误。这可能是 Xlrd 的问题吗?因为我可以在 Libreoffice 中打开 Excel 文件。

代码:

#!/usr/bin/python 
import xlrd 
 
xl_workbook = xlrd.open_workbook('/home/ubuntu/Downloads/usage01.12.2015_31.12.2015.xls') 
 
sheet_names = xl_workbook.sheet_names() 
print('Sheet Names', sheet_names) 

错误:

    0  5 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 
   20  4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 
   40= 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 
   60  4 4 3 2 
Traceback (most recent call last): 
  File "./forbruk.py", line 4, in <module> 
    xl_workbook = xlrd.open_workbook('/home/ubuntu/Downloads/usage01.12.2015_31.12.2015.xls') 
  File "/usr/local/lib/python2.7/dist-packages/xlrd-0.9.4-py2.7.egg/xlrd/__init__.py", line 441, in open_workbook 
    ragged_rows=ragged_rows, 
  File "/usr/local/lib/python2.7/dist-packages/xlrd-0.9.4-py2.7.egg/xlrd/book.py", line 87, in open_workbook_xls 
    ragged_rows=ragged_rows, 
  File "/usr/local/lib/python2.7/dist-packages/xlrd-0.9.4-py2.7.egg/xlrd/book.py", line 592, in biff2_8_load 
    cd.locate_named_stream(UNICODE_LITERAL(qname)) 
  File "/usr/local/lib/python2.7/dist-packages/xlrd-0.9.4-py2.7.egg/xlrd/compdoc.py", line 390, in locate_named_stream 
    d.tot_size, qname, d.DID+6) 
  File "/usr/local/lib/python2.7/dist-packages/xlrd-0.9.4-py2.7.egg/xlrd/compdoc.py", line 418, in _locate_stream 
    raise CompDocError("%s corruption: seen[%d] == %d" % (qname, s, self.seen[s])) 
xlrd.compdoc.CompDocError: Workbook corruption: seen[2] == 4 

请您参考如下方法:

如果你需要来自远程服务的数据,这是一个 hack,但是注释掉第 418 行 (raise CompDocError("%s corruption: seen[%d] == %d"% (qname, s, self .seen[s]))) 在 compdoc.py 中似乎工作正常。

另请查看此文档 source