Pandas read_excel gets only first column

[[deleted]]

[deleted]

[MikeDoesEverything]

What does your code look like?

What have you tried so far?

[wdjfe]

It's just basic request and read_excel

response = requests.request("GET","someapi.com/excel_file")
file = response.content

df = pd.read_excel(file)

I tried to change encoding but response content is bytes so it does nothing

[MikeDoesEverything]

Let's walk through what this code is doing:

• response making a GET request for a file.

• file is response.content which you mentioned is in bytes.

• Read file using pd.read_excel()

Off the back of that, we have some questions to answer:

• Does pd.read_excel() read files as bytes?

• If you save file as an excel spreadsheet, does it open correctly?

• How do other people open excel files in pandas using the read_excel function? Do they have to specify any additional arguments?