我正在尝试将Pandas Dataframe 保存为Excel表到一个SharePoint站点。我有两个独立的代码块来实现下面的功能。(感谢Stackoverflow社区)

1.在本地存储中使用ExcelWriter将PandasDF保存为EXCEL表的脚本。
1.可以将本地文件保存到Sharepoint Online的脚本。

我对如何将这两者结合起来将DF保存到SharePoint Online上感到非常困惑，但EXCEL文件应该是一个表，而不仅仅是一系列数据。请帮帮忙

脚本1将EXCEL范围保存为本地表

############################################################################## 

# 

# An example of adding a dataframe to an worksheet table in an xlsx file

# using Pandas and XlsxWriter.

# 

# Tables in Excel are used to group rows and columns of data into a single

# structure that can be referenced in a formula or formatted collectively.

# 

# SPDX-License-Identifier: BSD-2-Clause

# Copyright 2013-2021, John McNamara, jmcnamara@cpan.org

# 

import pandas as pd

# Create a Pandas dataframe from some data.

df = pd.DataFrame({
    'Country':    ['China',    'India',    'United States', 'Indonesia'],
    'Population': [1404338840, 1366938189, 330267887,       269603400],
    'Rank':       [1,          2,          3,               4]})

# Order the columns if necessary.

df = df[['Rank', 'Country', 'Population']]

# Create a Pandas Excel writer using XlsxWriter as the engine.

writer = pd.ExcelWriter('pandas_table.xlsx', engine='xlsxwriter')

# Write the dataframe data to XlsxWriter. Turn off the default header and

# index and skip one row to allow us to insert a user defined header.

df.to_excel(writer, sheet_name='Sheet1', startrow=1, header=False, index=False)

# Get the xlsxwriter workbook and worksheet objects.

workbook = writer.book
worksheet = writer.sheets['Sheet1']

# Get the dimensions of the dataframe.

(max_row, max_col) = df.shape

# Create a list of column headers, to use in add_table().

column_settings = [{'header': column} for column in df.columns]

# Add the Excel table structure. Pandas will add the data.

worksheet.add_table(0, 0, max_row, max_col - 1, {'columns': column_settings})

# Make the columns wider for clarity.

worksheet.set_column(0, max_col - 1, 12)

# Close the Pandas Excel writer and output the Excel file.

writer.save()

将任何文件保存到SharePoint的脚本2

from office365.runtime.auth.authentication_context import AuthenticationContext
from office365.sharepoint.client_context import ClientContext
import os 

baseurl = 'https://testsite.sharepoint.com/'
basesite = '/sites/project' # every share point has a home.
siteurl = baseurl + basesite 

localpath = "pandas_table.xlsx"
remotepath = "Shared Documents/General/file.xlsx" # existing folder path under sharepoint site.

ctx_auth = AuthenticationContext(siteurl)
ctx_auth.acquire_token_for_user(<username>, <password>)
ctx = ClientContext(siteurl, ctx_auth) # make sure you auth to the siteurl.

with open(localpath, 'rb') as content_file:
    file_content = content_file.read()

dir, name = os.path.split(remotepath)
file = ctx.web.get_folder_by_server_relative_url(dir).upload_file(name, file_content).execute_query()

我真的不确定如何将Writer.save()与SharePoint连接器一起使用。敬请提前告知感谢。