代码之家  ›  专栏  ›  技术社区  ›  guagay_wk

Pandas无法打开此Excel文件

  •  9
  • guagay_wk  · 技术社区  · 9 年前

    我正在尝试使用python pandas打开Excel文件。代码如下所示:;

    import pandas as pd
    df = pd.read_excel('../TestXLWings.xlsm', sheetname="TestSheet")
    

    Traceback (most recent call last):
      File "C:\Program Files\JetBrains\PyCharm Community Edition 2017.2\helpers\pydev\pydevd.py", line 1599, in <module>
        globals = debugger.run(setup['file'], None, None, is_module)
      File "C:\Program Files\JetBrains\PyCharm Community Edition 2017.2\helpers\pydev\pydevd.py", line 1026, in run
        pydev_imports.execfile(file, globals, locals)  # execute the script
      File "C:\Program Files\JetBrains\PyCharm Community Edition 2017.2\helpers\pydev\_pydev_imps\_pydev_execfile.py", line 18, in execfile
        exec(compile(contents+"\n", file, 'exec'), glob, loc)
      File "C:/Users/testing/Dropbox/Test-XLwings/test.py", line 3, in <module>
        df = pd.read_excel('../TestXLWings.xlsm', sheetname="TestSheet")
      File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\excel.py", line 203, in read_excel
        io = ExcelFile(io, engine=engine)
      File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\excel.py", line 260, in __init__
        self.book = xlrd.open_workbook(io)
      File "C:\ProgramData\Anaconda3\lib\site-packages\xlrd\__init__.py", line 441, in open_workbook
        ragged_rows=ragged_rows,
      File "C:\ProgramData\Anaconda3\lib\site-packages\xlrd\book.py", line 87, in open_workbook_xls
        ragged_rows=ragged_rows,
      File "C:\ProgramData\Anaconda3\lib\site-packages\xlrd\book.py", line 595, in biff2_8_load
        raise XLRDError("Can't find workbook in OLE2 compound document")
    xlrd.biffh.XLRDError: Can't find workbook in OLE2 compound document
    

    1 回复  |  直到 9 年前
        1
  •  17
  •   guagay_wk    9 年前

    我会回答我自己的问题。在ayhan的一条评论中,xlrd无法读取受Excel保护的文件。一种解决方案是移除保护。

    I need the command to unprotect an Excel file from python

    推荐文章