用Python代替Excel读取SharePoint数据查询.iqy

Question

我正在尝试用Python直接从SharePoint读取表。你知道吗

现在我只能用Excel。我从SharePoint导出查询并使用它的文本。你知道吗

import win32com.client
import pandas as pd

excel = win32com.client.Dispatch("Excel.Application")
excel.DisplayAlerts = False
excel.Visible = False
doc = excel.Workbooks.Open('query.iqy')
ExcelOrg = trgName.replace('query.iqy', 'query.xlsx')
doc.SaveAs(Filename=ExcelOrg, FileFormat=1)
doc.Close()
pd.read_excel(ExcelOrg)

那个查询.iqy文本为：

https://****.sharepoint.com/teams/HW/****/**/**/owssvr.dll?XMLDATA=1&List={****-0636-****-9C76-*****}&View=*****-****-****-****-******&RowLimit=0&RootFolder=undefined
SharePointApplication=https://****.sharepoint.com/teams/HW/****/**/***
SharePointListName={******-0636-4A72-*****-*********}

谢谢