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:
but now I need to read excel file from the folder Tools into a data frame. How to go about.
Source: Python Questions