Connect to an excel from Sharepoint using python

Question

I want to Connect to an excel from Sharepoint using python but it doesnt work.

My code:

df = pd.read_excel(url,sheet_name = 'Sheet1', header = 0, auth=(username, password))

My error:

TypeError: read_excel() got an unexpected keyword argument 'auth'

How can I connect?

find a solution at this problem

Does this answer your question? Read sharepoint excel file with python pandas — alphaBetaGamma
– alphaBetaGamma, Commented Dec 21, 2022 at 11:29
There are no auth argument there. Refer to the official document, ` pandas.read_excel(io, sheet_name=0, *, header=0, names=None, index_col=None, usecols=None, squeeze=None, dtype=None, engine=None, ...)` — Misinahaiya
– Misinahaiya, Commented Dec 21, 2022 at 11:34

BDurand · Accepted Answer · 2022-12-21 11:29:47Z

0

Sharepoint files are protected behing an authentification system, you first need to be able to connect to Sharepoint with your program using Sharepoint API before accessing the file.

See : https://learn.microsoft.com/en-us/answers/questions/78034/how-to-connect-python-program-to-sharepoint-rest-a.html

How to access a sharepoint site via the REST API in Python?

answered Dec 21, 2022 at 11:29

BDurand

4805 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Connect to an excel from Sharepoint using python

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