python xlrd unsupported format, or corrupt file.

by

Try to open it as an HTML with pandas:

import pandas as pd
data = pd.read_html('filename.xls')

Or try any other html python parser.

That’s not a proper excel file, but an html readable with excel.

More Related Contents:

  1. Pandas: Looking up the list of sheets in an excel file
  2. Reading Excel File using Python, how do I get the values of a specific column with indicated column name?
  3. Get formula from Excel cell with python xlrd
  4. Error: Unsupported format, or corrupt file: Expected BOF record
  5. Convert date from excel in number format to date format python [duplicate]
  6. How to obtain sheet names from XLS files without loading the whole file?
  7. Insert row into Excel spreadsheet using openpyxl in Python
  8. Edit existing excel workbooks and sheets with xlrd and xlwt
  9. Identifying Excel Sheet cell color code using XLRD package
  10. Export a list of stock prices to excel
  11. How to write to an existing excel file without overwriting data (using pandas)?
  12. Preserving styles using python’s xlrd,xlwt, and xlutils.copy
  13. How to convert a given ordinal number (from Excel) to a date
  14. Editing workbooks with rich text in openpyxl
  15. How to open a password protected excel file using python?
  16. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  17. How can I see the formulas of an excel spreadsheet in pandas / python?
  18. Python: Open Excel Workbook using Win32 COM Api
  19. Python xlwt – accessing existing cell content, auto-adjust column width
  20. how to write to a new cell in python using openpyxl
  21. Putting many python pandas dataframes to one excel worksheet
  22. Python openpyxl data_only=True returning None
  23. Pandas: Reading Excel with merged cells
  24. openpyxl load_workbook() on a legit .xlsx file leads to a zipfile.BadZipFile error
  25. Can Pandas read and modify a single Excel file worksheet (tab) without modifying the rest of the file?
  26. Get cell color from .xlsx
  27. Export Charts from Excel as images using Python
  28. Automation Excel from Python
  29. Appending Pandas DataFrame to existing Excel document
  30. XlsxWriter object save as http response to create download in Django

Leave a Comment