无法从Python执行Excel的SQL查询

Question

我正在设置ADODB与Excel数据源的连接。我想执行SQL查询，但它失败了，错误出现在下面代码的最后一行：

com_error(-2147352567, 'Exception occurred.', (0, 'Microsoft Access Database Engine', "'Query1$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.", None, 5003125, -2147467259), None)

wb = xlapp.workbooks.open("connectionTestExcel.xlsx")

ado_conn = win32com.client.gencache.EnsureDispatch('ADODB.Connection')

ado_conn.ConnectionString = "Provider = Microsoft.ACE.OLEDB.12.0; Data Source = C:\\Users\\User1\\Documents\\connectionTestExcel.xlsx; Extended Properties ='Excel 12.0 Xml;HDR=YES'";

ado_conn.Open()

ado_rst = win32com.client.gencache.EnsureDispatch('ADODB.Recordset')

c = ado_rst.Open("SELECT TOP 10 * FROM [Query1$]", ado_conn)