请看下面的代码:
import pandas
df = pandas.read_excel('cat.xlsx')
运行后,它给我以下错误:
Traceback (most recent call last):
File "d:\OneDrive\桌面\practice.py", line 4, in <module>
df = pandas.read_excel('cat.xlsx')
File "D:\python\lib\site-packages\pandas\util\_decorators.py", line 296, in wrapper
return func(*args, **kwargs)
File "D:\python\lib\site-packages\pandas\io\excel\_base.py", line 304, in read_excel
io = ExcelFile(io, engine=engine)
File "D:\python\lib\site-packages\pandas\io\excel\_base.py", line 867, in __init__
self._reader = self._engines[engine](self._io)
File "D:\python\lib\site-packages\pandas\io\excel\_xlrd.py", line 22, in __init__
super().__init__(filepath_or_buffer)
File "D:\python\lib\site-packages\pandas\io\excel\_base.py", line 353, in __init__
self.book = self.load_workbook(filepath_or_buffer)
File "D:\python\lib\site-packages\pandas\io\excel\_xlrd.py", line 37, in load_workbook
return open_workbook(filepath_or_buffer)
File "D:\python\lib\site-packages\xlrd\__init__.py", line 170, in open_workbook
raise XLRDError(FILE_FORMAT_DESCRIPTIONS[file_format]+'; not supported')
xlrd.biffh.XLRDError: Excel xlsx file; not supported
我已尝试使用pip命令卸载并重新安装Pandas,但错误仍然存在。我已安装xlrd 2.0.1和Pandas 1.1.5。
pandas
版本和xlrd
版本,请执行pip freeze | findstr pandas
和pip freeze | findstr xlrd
。预计你正在使用Python3。 - รยקคгรђשคxls
格式以外的任何内容。您可以使用其他引擎,比如openpyxl
。 - รยקคгรђשคpandas
升级到1.2.0
版本解决了问题(我使用的是xlrd
2.0.1)。 - jjrr