使用xlrd读取excel文件时报错,
Traceback (most recent call last):
File "D:\Program Files\JetBrains\PyCharm 2020.1.1\plugins\python\helpers\pydev\pydevd.py", line 1438, in _exec
pydev_imports.execfile(file, globals, locals) # execute the script
File "D:\Program Files\JetBrains\PyCharm 2020.1.1\plugins\python\helpers\pydev\_pydev_imps\_pydev_execfile.py", line 18, in execfile
exec(compile(contents+"\n", file, 'exec'), glob, loc)
File "E:/ToExcel/test.py", line 15, in <module>
read_book = xlrd.open_workbook(r'abc.xlsx')
File "D:\Users\gp\AppData\Local\Programs\Python\Python38\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
解决办法:
一、可以把文件后缀改成.xls
二、目前用的版本是xlrd-2.0.1,可以将这个版本卸载,安装低版本pip install xlrd==1.2.0