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, Sep 23 '20 at 05:07

Hofbr · Answer 1 · 2022-06-13T17:40:48.870

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 '22 at 17:40

answered Sep 23 '20 at 05:19

Hofbr

868
9
31

I am getting NameError: name 'output' is not defined. Also response.content is giving me b'403 FORBIDDEN' – rsc05 Jun 10 '22 at 10:37
1

You have to put output.xlsx inside "", like "output.xlsx" – ignacioct Jun 13 '22 at 09:26
Didn't notice that typo. I've updated. – Hofbr Jun 13 '22 at 17:45

Download excel files from SharePoint document library using python

1 Answers1