是的您可以使用https://github.com/vgrem/Office365-REST-Python-Client

download_path = os.path.join(tempfile.mkdtemp(), os.path.basename(FILE_URL))
with open(download_path, "wb") as local_file:
   ctx.web.get_file_by_server_relative_url(FILE_URL).download(local_file).execute_query()

然后读取下载路径
下载pd.read路径
不要删除临时文件！
库是惊人的，你也可以直接读取sharepoint文件在字节Ex：

def read_csv(ctx, relative_url, pandas=False):
    # relative_url = "/sites/myLib/Folder/test.csv" #TEST
    # ctx = auth()
    response = File.open_binary(ctx, relative_url)
    bytes_data = response.content
    try:
        s = str(bytes_data, 'utf8')
    except Exception as e:
        print('utf8 encoding error')
        print(relative_url, e)
        try:
            s = str(bytes_data, 'cp1252')
        except Exception as e:
            print('CRITIAL ERROR cp1252 encoding error')
            print(relative_url, e)
    if pandas == False:
        return s
    else:
        data = StringIO(s)
        return data

我使用了panadas变量bc，最终代码如下所示

df= pd.read_csv(read_csv(ctx=ctx, relative_url=FILE_URL, pandas=True), dtype=str, keep_default_na=False) # read master qrd db