问题描述
今天在测试 python 读取excel文件的时候出现了异常
Traceback (most recent call last):
File "E:/worksp_py/hardwary/100day/thirtfive/testxml.py", line 5, in <module>
wb = xlrd.open_workbook("./test.xlsx")
File "E:\Tools\anaconda3\envs\pytorch\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 安装的 xlrd 默认版本不支持读取 xlsx
解决方式
先卸载
E:\worksp_py\hardwary>pip uninstall xlrd
Found existing installation: xlrd 2.0.1
Uninstalling xlrd-2.0.1:
Would remove:
e:\tools\anaconda3\lib\site-packages\xlrd-2.0.1.dist-info\*
e:\tools\anaconda3\lib\site-packages\xlrd\*
e:\tools\anaconda3\scripts\runxlrd.py
Proceed (Y/n)? y
Successfully uninstalled xlrd-2.0.1
安装低版本xlrd
pip install xlrd==1.2.0
另一个解决方式将 xlsx 另存为 xls