执行文件出现以下错误
D:\PycharmProjects\pythonProject\venv\Scripts\python.exe D:\PycharmProjects\pythonProject\index.py
Traceback (most recent call last):
File "D:\PycharmProjects\pythonProject\index.py", line 2, in <module>
data = xlrd.open_workbook("changtai.xlsx")
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\PycharmProjects\pythonProject\venv\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
Process finished with exit code 1
原因
xlrd版本无法读取
解决方法如下
(1)检查第三方版本库
我这里的版本为 xlrd2.0.1 最新版本,问题就出在这里,需要卸载最新版本,安装旧版本,卸载安装过程如下
(2)修改