xlrd.biffh.XLRDError: Excel xlsx 文件；不支持 [英] xlrd.biffh.XLRDError: Excel xlsx file; not supported

问题描述

我正在尝试使用带有 xlrd 库的 pandas.read_excel 读取启用宏的 Excel 工作表.它在本地运行良好，但是当我尝试将其推送到 PCF 时，出现此错误:

I am trying to read a macro-enabled Excel worksheet using pandas.read_excel with the xlrd library. It's running fine in local, but when I try to push the same into PCF, I am getting this error:

2020-12-11T21:09:53.441+05:30 [APP/PROC/WEB/0] [ERR] df1=pd.read_excel(os.path.join(APP_PATH, os.path.join("Data", "aug_latest.xlsm")),sheet_name=None)

2020-12-11T21:09:53.441+05:30 [APP/PROC/WEB/0] [ERR] return open_workbook(filepath_or_buffer)
2020-12-11T21:09:53.441+05:30 [APP/PROC/WEB/0] [ERR] File "/home/vcap/deps/0/python/lib/python3.8/site-packages/xlrd/__init__.py", line 170, in open_workbook
2020-12-11T21:09:53.441+05:30 [APP/PROC/WEB/0] [ERR] raise XLRDError(FILE_FORMAT_DESCRIPTIONS[file_format]+'; not supported')
2020-12-11T21:09:53.441+05:30 [APP/PROC/WEB/0] [ERR] xlrd.biffh.XLRDError: Excel xlsx file; not supported

我该如何解决这个错误?

How can I resolve this error?

推荐答案

如 发布电子邮件，链接自发布推文并在出现在文档的首页上的大橙色警告中指出，并且橙色较少，但仍然存在，在存储库上的自述文件和在 pypi 上发布:

As noted in the release email, linked to from the release tweet and noted in large orange warning that appears on the front page of the documentation, and less orange, but still present, in the readme on the repository and the release on pypi:

xlrd 已明确删除对 xls 文件以外的任何内容的支持.

在您的情况下，解决方案是:

In your case, the solution is to:

• 确保您使用的是最新版本的 Pandas，至少 1.0.1，最好是最新版本.1.2 将使他的更清楚.
• 安装openpyxl:https://openpyxl.readthedocs.io/en/稳定/
• 将您的 Pandas 代码更改为:

• make sure you are on a recent version of Pandas, at least 1.0.1, and preferably the latest release. 1.2 will make his even clearer.
• install openpyxl: https://openpyxl.readthedocs.io/en/stable/
• change your Pandas code to be:

df1 = pd.read_excel(
     os.path.join(APP_PATH, "Data", "aug_latest.xlsm"),
     engine='openpyxl',
)

这篇关于xlrd.biffh.XLRDError: Excel xlsx 文件；不支持的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！