Download excel files from SharePoint document library using python

Question

I am trying to download excel files from my work SharePoint site to a local folder using python. I have written a code to successfully authenticate into the sharepoint site.But need help in downloading the Excel files from the sharepoint document library. I am new to Python and would really appreciate your help :) Below is my code :

import urllib.request
import requests
from requests_ntlm import HttpNtlmAuth


def sharepointlogin():
    site = "https://abc.sharepoint.com/site"
    username = "*******"
    password = "*******"

    response = requests.get(site, auth=HttpNtlmAuth(username, password))
    print(response.status_code)

def filedownload():

    print('Downloading file')

    url = 'https://abc.sharepoint.com'
    urllib.request.urlretrieve(url, 'C:\Downloads\filename.xlsx')

    print("File Downloaded")

    print("Download complete")


sharepointlogin()

filedownload()

What error are you running into when you run this code? Is it not working as intended? — Hofbr
– Hofbr, Commented Sep 23, 2020 at 5:07

Hofbr · Accepted Answer · 2022-06-13 17:40:48Z

1

import requests

from getpass import getpass
from requests_ntlm import HttpNtlmAuth

url = "https://share.something.com/path/file.xlsx"

session = requests.Session()
session.verify = False

username = input("Enter your username: ")
password = getpass("Enter your password: ")

session.auth = HttpNtlmAuth(username, password)
response = session.get(url)

with open("output.xlsx", wb) as f:
    f.write(response.content)

edited Jun 13, 2022 at 17:40

answered Sep 23, 2020 at 5:19

Hofbr

1,0201 gold badge18 silver badges43 bronze badges

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

5 Comments

rsc05 Over a year ago

I am getting NameError: name 'output' is not defined. Also response.content is giving me b'403 FORBIDDEN'

ignacioct Over a year ago

You have to put output.xlsx inside "", like "output.xlsx"

Hofbr Over a year ago

Didn't notice that typo. I've updated.

Gilbert V Jun 11 at 17:52

Would this work for SharePoint Online ?

Gilbert V Jun 11 at 17:53

there is no hidden excel it is a sharepoint list that I want to turn into a excel

Collectives™ on Stack Overflow

Download excel files from SharePoint document library using python

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related