Uploading multiple excel files using Sharepy to Sharepoint

Question

I am trying to create a python script that imports files from a desktop folder to a Sharepoint sites folder.

I am using Sharepy to perform this task.

This is the script I have currently:

import sharepy
import os
import glob

s = sharepy.connect("https://xxx.sharepoint.com", username='[email protected]', password='xxx')

filesToUpload = (glob.glob("C:/Users/xxx/Desktop/xxx/*.xlsx"))

for fileToUpload in filesToUpload:
            headers = {"accept": "application/json;odata=verbose",
            "content-type": "application/x-www-urlencoded; charset=UTF-8"}

            with open(fileToUpload, 'rb') as read_file:
                content = read_file.read()

            p = s.post(f"https://xxx.sharepoint.com/xxx/yyy/_api/web\
            /GetFolderByServerRelativeUrl('/xxx/yyy/Shared Documents/zzz/aaa/')/Files/add(url='fileToUpload',overwrite=true)", data=content, headers=headers)

It works fine when I do it one at a time but not with this loop. I have about 5 xlsx excel sheets in my folder currently.

How can I upload multiple files with a single request?

Maher Kebaier · Accepted Answer · 2020-12-02 13:04:38Z

3

Can you try to put the files to import into a list which you will loop over?

Try this :

import os
import glob

s = sharepy.connect("https://xxx.sharepoint.com", username='[email protected]', password='xxx')

filesToUpload = [f for f in glob.glob("*.txt")]   #New line

for fileToUpload in filesToUpload:
            headers = {"accept": "application/json;odata=verbose",
            "content-type": "application/x-www-urlencoded; charset=UTF-8"}

            with open(fileToUpload, 'rb') as read_file:
                content = read_file.read()

            p = s.post(f"https://xxx.sharepoint.com/xxx/yyy/_api/web\
            /GetFolderByServerRelativeUrl('/xxx/yyy/Shared Documents/zzz/aaa/')/Files/add(url='fileToUpload',overwrite=true)", data=content, headers=headers)

edited Dec 2, 2020 at 13:04

answered Dec 1, 2020 at 21:58

Maher Kebaier

1233 silver badges15 bronze badges

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

2 Comments

Jon Mitten Over a year ago

Can you show an example of this method in code?

Maher Kebaier Over a year ago

If my code does the job, mark my solution

Collectives™ on Stack Overflow

Uploading multiple excel files using Sharepy to Sharepoint

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related