db = QSqlDatabase.addDatabase("QODBC3") if not db.isValid(): print("database is not valid!") else: d4 = 'DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=d:\\xls\\12.xlsx' db.setDatabaseName(d4) if not db.open(): print("Database Open Failed!") print(db.lastError().text()) tables = db.tables() query = QSqlQuery(db) sql = "select * from [汇总$]" query.exec(sql)
执行情况如下:
如上图,为什么tables()返回为空,但实际上,通过select语句能根据表的名称查询到表的数据。
请教大神们!