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

Michael Zippo

👻 Check our latest review to choose the best laptop for Machine Learning engineers and Deep learning tasks!

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?

👻 Read also: what is the best laptop for engineering students?

We hope this article has helped you to resolve the problem. Apart from xlrd.biffh.XLRDError: Excel xlsx file; not supported, check other code Python module-related topics.

Want to excel in Python? See our review of the best Python online courses 2023. If you are interested in Data Science, check also how to learn programming in R.

By the way, this material is also available in other languages:

Julia OConnell

Moscow | 2023-04-01

I was preparing for my coding interview, thanks for clarifying this - xlrd.biffh.XLRDError: Excel xlsx file; not supported in Python is not the simplest one. Checked yesterday, it works!

Jan OConnell

Rome | 2023-04-01

code Python module is always a bit confusing 😭 xlrd.biffh.XLRDError: Excel xlsx file; not supported is not the only problem I encountered. Checked yesterday, it works!

Walter Krasiko

Massachussetts | 2023-04-01

code Python module is always a bit confusing 😭 xlrd.biffh.XLRDError: Excel xlsx file; not supported is not the only problem I encountered. I am just not quite sure it is the best method