0

I have ~300 .xls files that I need to import to Python. I've tried xlrd and pandas read_excel and both fail the import with "Unsupported format, or corrupt file: Expected BOF record; found '="XS1351'.

Roughly half the columns on each sheet have quotes and leading equalsign ="THISFORMAT"

The other half have no quotes or special characters. Any help is much appreciated

CJones
  • 587
  • 2
  • 5
  • 11

1 Answers1

1

I know it's not the solution you're looking for, but you could go to CSV first, then import to Python. Here is a way to convert quickly. I have also tried to import .xls files to great frustration and ended up manually opening 25 or so of them and saving as CSV.

Will
  • 87
  • 6