xlrd.biffh.XLRDError: Excel xlsx file; not supported [duplicate]

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 repository and the release on pypi:

xlrd has explicitly removed support for anything other than xls 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. 1.2 will make his
    even clearer.
  • install openpyxl: https://openpyxl.readthedocs.io/en/stable/
  • change your Pandas code to be: 
    df1 = pd.read_excel(
     os.path.join(APP_PATH, "Data", "aug_latest.xlsm"),
     engine="openpyxl",
)

More Related Contents:

  1. GroupBy results to dictionary of lists
  2. Pandas: Looking up the list of sheets in an excel file
  3. How to obtain sheet names from XLS files without loading the whole file?
  4. python: update dataframe to existing excel sheet without overwriting contents on the same sheet and other sheets
  5. converting a text file to csv file with out index
  6. Error: pandas hashtable keyerror
  7. Writing a pandas DataFrame to CSV file
  8. pandas: How do I split text in a column into multiple rows?
  9. Find row where values for column is maximal in a pandas DataFrame
  10. How to filter rows containing a string pattern from a Pandas dataframe [duplicate]
  11. python/pandas: convert month int to month name
  12. Convert pandas Series to DataFrame
  13. Comparing two pandas dataframes for differences
  14. Remove name, dtype from pandas output of dataframe or series
  15. Export pandas Styled table to image file
  16. pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
  17. How do I filter a pandas DataFrame based on value counts?
  18. Lambda including if…elif…else
  19. Create bool mask from filter results in Pandas [duplicate]
  20. Getting a list of indices where pandas boolean series is True
  21. Pandas DataFrame sort by categorical column but by specific class ordering
  22. How can I remove extra whitespace from strings when parsing a csv file in Pandas?
  23. convert entire pandas dataframe to integers in pandas (0.17.0)
  24. Remove NaN values from pandas dataframe and reshape table [duplicate]
  25. Calculate summary statistics of columns in dataframe
  26. pandas plot value counts barplot in descending manner [duplicate]
  27. Pandas: Join dataframe with condition
  28. UnicodeDecodeError when reading CSV file in Pandas
  29. How to create a scatter plot by category [duplicate]
  30. What is the Spark DataFrame method `toPandas` actually doing?

Leave a Comment