How can we solve the XLRDError (Excel xlsx file; not supported) because the support has been removed for xlsx type files in read_excel.
Due to which we encounter the “XLRDError: Excel xlsx file; not supported” while using their read_excel function from the pandas' package.
Pandas use the xlrd as their default engine for reading excel files in the previous versions. However, now xlrd has removed support for anything other than xls files in their latest release.
It causes the error that the xlsx filetype is no longer supported when calling the read_excel function on a xlsx excel using pandas.
The solution of this is the following:
- First, Install openpyxl: This is another excel package that still supports the xlsx format.
- Second, Set the engine to “openpyxl” instead of the default “xlrd”.
