使用Sharepy将多个excel文件上传到Sharepoint

import os
from sharepy import connect

def upload_excel_to_sharepoint(site_url, username, password, folder_path, excel_files):
    # 连接到Sharepoint
    s = connect(site_url, username, password)

    # 遍历所有Excel文件
    for file in excel_files:
        file_path = os.path.join(folder_path, file)
        
        # 上传文件到Sharepoint
        with open(file_path, 'rb') as f:
            s.put(f'/sites/{site_url}/Shared Documents/{file}', data=f.read())

site_url = 'https://your_sharepoint_site_url'
username = 'your_username'
password = 'your_password'
folder_path = 'path_to_folder_containing_excel_files'
excel_files = ['file1.xlsx', 'file2.xlsx', 'file3.xlsx']

upload_excel_to_sharepoint(site_url, username, password, folder_path, excel_files)