使用Python comtypes库向Excel添加查询表时出现问题

pip install comtypes

from comtypes.client import CreateObject

excel = CreateObject('Excel.Application')
workbook = excel.Workbooks.Open('your_excel_file.xlsx')

# Create a new worksheet for the query table
worksheet = workbook.Worksheets.Add()

# Create the query table
query_table = worksheet.QueryTables.Add(Connection='your_connection_string', Destination=worksheet.Range('A1'))

# Set query table properties
query_table.Name = 'YourQueryTableName'
query_table.FieldNames = True
query_table.RowNumbers = False
query_table.FillAdjacentFormulas = False
query_table.PreserveFormatting = True
query_table.RefreshOnFileOpen = False
query_table.BackgroundQuery = True
query_table.RefreshStyle = 1
query_table.SavePassword = False
query_table.SaveData = True
query_table.AdjustColumnWidth = True
query_table.RefreshPeriod = 0
query_table.PreserveColumnInfo = True
query_table.EnableEditing = True
query_table.Refresh()