Pandas cannot open an Excel (.xlsx) file

by

As noted in the release email, linked to from the release tweet and noted in large orange warning that appears on the front page of the documentation, and less orange but still present in the readme on the repo and the release on pypi:

xlrd has explicitly removed support for anything other than xls files.

This is due to potential security vulnerabilities relating to the use of xlrd version 1.2 or earlier for reading .xlsx files.

In your case, the solution is to:

  • make sure you are on a recent version of pandas, at least 1.0.1, and preferably the latest release.
  • install openpyxl: https://openpyxl.readthedocs.io/en/stable/
  • change your pandas code to be: 
    pandas.read_excel('cat.xlsx', engine="openpyxl")

Edit: Currently, pandas >= 1.2 addresses this issue. (Release Notes)

More Related Contents:

  1. How to write to an existing excel file without overwriting data (using pandas)?
  2. Append existing excel sheet with new dataframe using python pandas
  3. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  4. Convert Excel style date with pandas
  5. Import multiple excel files into python pandas and concatenate them into one dataframe
  6. Could pandas use column as index?
  7. Pandas: Looking up the list of sheets in an excel file
  8. append dataframe to excel with pandas
  9. pandas xlsxwriter, format table header – not sheet header
  10. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  11. Refresh Excel External Data with Python
  12. drop_duplicates not working in pandas?
  13. How can I see the formulas of an excel spreadsheet in pandas / python?
  14. How to obtain sheet names from XLS files without loading the whole file?
  15. Write pandas dataframe to xlsm file (Excel with Macros enabled)
  16. Merge rows based on value (pandas to excel – xlsxwriter)
  17. From password-protected Excel file to pandas DataFrame
  18. Write to StringIO object using Pandas Excelwriter?
  19. Leave dates as strings using read_excel function from pandas in python
  20. Putting many python pandas dataframes to one excel worksheet
  21. Pandas: Reading Excel with merged cells
  22. Can Pandas read and modify a single Excel file worksheet (tab) without modifying the rest of the file?
  23. Pandas: parse merged header columns from Excel
  24. Python Pandas – Read csv file containing multiple tables
  25. How to write to an existing excel file without breaking formulas with openpyxl?
  26. Appending Pandas DataFrame to existing Excel document
  27. Expanding pandas data frame with date range in columns
  28. Python Pandas: Get index of rows where column matches certain value
  29. Format a number with commas to separate thousands
  30. Pandas: select all dates with specific month and day

Leave a Comment