1

I have a .xls file that I have no trouble opening in Excel. Unfortunately, when trying to call the following function from the pandas module:

survey = pd.read_excel('ISU_Anketa_Ishodnie.xls', skiprows=1)

I receive the following error:

XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b''<'?xml ve'

I have tried saving that file in .csv format, but the only option Excel provides for delimiter is a comma, which is a problem as the data itself includes a lot of commas.

Igor Glukhov
  • 19
  • 1
  • Maybe this can help you with your issue: https://stackoverflow.com/questions/23994362/xlrd-reading-xls-xlrderror-unsupported-format-or-corrupt-file-expected-bof-re – powerPixie Dec 08 '19 at 09:28
  • 3
    Does this answer your question? [python xlrd unsupported format, or corrupt file.](https://stackoverflow.com/questions/9623029/python-xlrd-unsupported-format-or-corrupt-file) – powerPixie Dec 08 '19 at 09:29
  • try to write survey = pd.read_html("ISU_Anketa_Ishodnie.xls", skiprows=1) – Vishav Gupta Dec 08 '19 at 09:30
  • can you share us an example about your file ? – GiovaniSalazar Dec 08 '19 at 21:49

0 Answers0