Read excel file in Dataframe from Share Point using python

  python

I have to read the excel files from share point. I need to use the default password as I have access to sharepoint.

import requests
from requests_negotiate_sspi import HttpNegotiateAuth
 
response = requests.get(
    r'https://sharepoint.io.com/site3516/COURM/Tools',
    auth=HttpNegotiateAuth(),
    verify=False
    )

print(response.status_code) 

The code prints 200 as the status code.

I have followed the below link:
https://qurios-it.de/2020/10/16/connecting-to-sharepoint-using-python/

but now I need to read excel file from the folder Tools into a data frame. How to go about.

Source: Python Questions

LEAVE A COMMENT