xlrd.biffh.XLRDError:Excel xlsx 文件;不支持

| | | | | | | | | | |

我正在嘗試使用帶有 xlrd 庫的 pandas.read_excel 讀取啟用宏的 Excel 工作表。它在本地運行良好,但是當我嘗試將其推送到 PCF 中時,出現此錯誤:

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(“數據”, “aug_latest.xlsm” ;)),sheet_name=None) 2020-12-11T21:09:53.441+05:30 [APP/PROC/WEB/0] [ERR] 返回 open_workbook(filepath_or_buffer) 2020-12-11T21:09:53.441+05: 30 [APP/PROC/WEB/0] [ERR] 文件“/home/vcap/deps/0/python/lib/python3.8/site-packages/xlrd/__init__.py”,第 170 行,在 open_workbook 2020 -12-11T21:09:53.441+05:30 [APP/PROC/WEB/0] [ERR] 引發 XLRDError(FILE_FORMAT_DESCRIPTIONS[file_format]+"; 不支持") 2020-12-11T21:09:53.441+05: 30 [APP/PROC/WEB/0] [ERR] xlrd.biffh.XLRDError: Excel xlsx file; not supported 

我該如何解決這個錯誤?