Excel file not supported by pandas

Question

Unsupported format, or corrupt file: Expected BOF record; found b'<H1 alig' I get this error when I try to connect by excel file with pandas.

What happens when you save a sheet from the file as `.csv` and read it into pandas? — hilberts_drinking_problem, Feb 04 '22 at 09:54
Have a look at this thread. [LINK](https://stackoverflow.com/questions/16504975/error-unsupported-format-or-corrupt-file-expected-bof-record) — Mattis Seehaus, Feb 04 '22 at 10:27
It would be helpful if you show us your code and explain in more detail. Have you seen this, https://stackoverflow.com/questions/16504975/error-unsupported-format-or-corrupt-file-expected-bof-record? — Park, Feb 04 '22 at 14:33

score 0 · Answer 1 · edited Feb 04 '22 at 18:04

0

Answer:

import pandas as pd
data=pd.read_html('File_name.xls')[0]
data.to_excel('NewFile_name.xlsx')

edited Feb 04 '22 at 18:04

Park

answered Feb 04 '22 at 13:28

Rahul Singh

1 Answers1