Reading .xlsx file from sharepoint v7.9

Ignition
1

Hi All,

I am trying to find a method to read .xlsx file from SharePoint. Would need your help to do it effectively.

Trying to access HTTP

url = system.net.httpPut("Share point link here")
print url

and getting error

Traceback (most recent call last):
File "<buffer>", line 15, in <module>
IOError: Server returned HTTP response code: 403 for URL: SharePoint Here

Blockquote

2

httpPut would send a file to a target server. Try httpGet.

1 Like
3

Hi,
I am receiving same error here

url=system.net.httpGet("https link here")
4

Well, that response means “forbidden”. You will need to show more details for us to help you, but you will at least need to authenticate to Sharepoint. v7.9 has a less than optimal implementation–the httpClient tool in v8.x is probably needed. Or perhaps using an ancient (python 2.5.2 compatible) version of the python requests module.