xlsl打开.xlsx格式表格报错：xlrd\init.py XLRDError(FILE_FORMAT_DESCRIPTIONS[file_format]+‘； not supported‘

原创已于 2022-03-12 16:43:22 修改 · 1.8k 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#python #pycharm #开发语言

于 2022-03-12 16:42:11 首次发布

python 专栏收录该内容

2 篇文章

订阅专栏

本文档讲述了在使用Python库xlrd处理1.xlsx文件时遇到的错误，原因在于xlrd-2.0.1版本不支持.xlsx格式。通过卸载旧版本并安装低版本xlrd-1.2.0，解决了此问题。

用xlrd打开1.xlsx表格报错：xlrd_init_.py XLRDError(FILE_FORMAT_DESCRIPTIONS[file_format]+’; not supported’)

xlrd.biffh.XLRDError: Excel xlsx file; not supported

项目场景：

用xlrd打开1.xlsx表格报错

问题描述

D:\Install\Python3.8.1\python.exe D:/WorkSpase/pythonProject/pythonProject/demo03/test.py
Traceback (most recent call last): File “D:/WorkSpase/pythonProject/pythonProject/demo03/test.py”, line 3, in xlsx = xlrd.open_workbook(‘1.xlsx’) File “D:\Install\Python3.8.1\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

D:\Install\Python3.8.1\python.exe D:/WorkSpase/pythonProject/pythonProject/demo03/test.py
Traceback (most recent call last):
  File "D:/WorkSpase/pythonProject/pythonProject/demo03/test.py", line 3, in <module>
    xlsx = xlrd.open_workbook('1.xlsx')
  File "D:\Install\Python3.8.1\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