Python: How to read excel file from Requests response?

Question

I am downloading an excel file as a stream using the requests library.

r = requests.get(my_url, stream=True)

I want to read the data in this excel file, for that I can am trying to use pandas. But I am not sure how to read the file from the response I get. What can I do?

Community · Accepted Answer · 2023-07-26 13:05:54Z

23

You can use a url in pandas directly to read the excel file without using requests.

import pandas as pd

df = pd.read_excel(my_url)

If it is necessary to retreive the data via requests, then this answer from here (How to download a Excel file from behind a paywall into a pandas dataframe?) may suffice:

Simply wrap the file contents in a BytesIO:

import pandas as pd
import io

with io.BytesIO(r.content) as fh:
    df = pd.io.excel.read_excel(fh, sheet_name=0) #sheetname becomes sheet_name

edited Jul 26, 2023 at 13:05

CommunityBot

11 silver badge

answered Sep 28, 2019 at 15:29

linamnt

1,4021 gold badge13 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python: How to read excel file from Requests response?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related