Download excel file from sharepoint python

Copy link. It seems the problem is that the URL for the spreadsheet I'm trying to download contains a question mark due to there being query parameters Thanks for responding, but again, the Sharepoint URL for the Excel file I'm trying to download specifies query-string parameters NET script, 'doc. So the URL really isn't specifying a direct folder path to the Excel file. Am also having the same issue, URL is not clean as you suggest. Sign up for free to join this conversation on GitHub. Already have an account?

Connect and share knowledge within a single location that is structured and easy to search. I'm trying to download an Excel file from a SharePoint repository using a Python script.

The problem comes when I want to download any of the files. I've tried several approaches, but none of them works: wget.

Do you know a way of downloading that file with wget using the authentication? Or am I doing something wrong in the requests. I need a way of getting that file, using the previous authentication I did at the begining of the script:.

Do you know a way of doing this? Maybe the python Client has a method for downloading the files but I can't find it! I found the solution!! I needed to get the authorization before I can download the file. I found an example within the test folder of the OfficePython-Client.

Improve this answer. Cilantro Ditrek 1 1 gold badge 14 14 silver badges 24 24 bronze badges. Dan Dan 5 5 silver badges 14 14 bronze badges. I found I needed to pass just the host to AuthenticationContext , but the site to the ClientContext , i. Dan , this looks great! The access policy does not allow token issuance. Does it mean I need to talk to my company's IT to unblock it? Starting from version 2. Why is "unquote" needed? I see it comes from library to parse URL. Ending is some sort of random numbers.

I forgot to import Path, I correct this in the edit by adding "from pathlib import Path" The unquote is needed for special characters in the filename. Suppose the document is called "my report.

Most people prefer to see "my report. Thanks for additional info. Excel file is now being downloaded but it is corrupted or incomplete. I ma not able to open it. URL ends exactly like that Show 4 more comments. Also note that the url is slightly different than you expect. Ferhat Ferhat 1 1 gold badge 2 2 silver badges 10 10 bronze badges. Sign up or log in Sign up using Google.

Find threads, tags, and users Current Visibility: Visible to all users. Comment Show 0. Related Questions.