This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!
- edited on
When using a python tool with pandas package, xlrd is unable to read .xlsx files, only .xls.
XLRD Error: Excel xlsx file; not supported
xlrd 2.0.0 and above can only read .xls files. Support for .xlsx files was removed from xlrd due to a potential security vulnerability.
import pandas as pd
df = pandas.read_excel(`<name-of-file>.xlsx`, engine=`openpyxl`)