1、连接2007及之前的excel
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
QString dbName="Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=D:\\book.xls";
db.setDatabaseName(dbName);
db.open();
注意Driver与(间要有空格
DBQ表示要连接的excel文件
查询时表名后要加$ ,用[]括起来,如要查询表sheet1的所有记录,用select * from [sheet1$]
参考资料:
http://www.connectionstrings.com/excel-2007/#p116