I am trying to fetch data from a .xlsx file but consistently getting this error
XLRDError: Excel xlsx file; not supported
This error only arises when trying to use XLRD library to open .xlsx files as xlrd only provides support for .xls files.
Acc to the official website excelrobot is based on openpyxl as well as xlrd, xlwt etc etc.
So if I am trying to fetch .xlsx file- why is it trying to open it specifically using xlrd and not openpyxl?
(I have imported datadriver library and excelrobot library. )