Qt通过odbc读取excel数据

//文件路径
QString filePath;
//桌面打开

//Qt4
//QString desktopDir=QDesktopServices::storageLocation(QDesktopServices::DesktopLocation);
//Qt 5
QString desktopDir=QStandardPaths::writableLocation(QStandardPaths::DesktopLocation);
filePath=QFileDialog::getOpenFileName(parent,"选择Excel",desktopDir,"*.xls");
if(filePath.isNull()){
    error="无法打开excel文件"; 
    return;
}
//读取excel
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC","excel");
if( !db.isValid())
{
    error="数据库驱动异常";
    return;  

}

QString dsn = "DRIVER={Microsoft Excel Driver (*.xls)};"
              "DSN=‘‘;DBQ="+filePath;
db.setDatabaseName(dsn);

// open connection
if( !db.open())
{
    error="无法打开数据库";
    return;  

}

QSqlQuery query(db);
QSqlRecord record;

QString tableName = "sheet1$"; //sheet名，$是必须的 
QString sql="select * from ["+tableName+"]";