Qt how to connect to .xlsx via ODBC?

Question

Qt

Hello, there is a code (taken from Qt wiki):

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName("DRIVER={Microsoft Excel Driver (*.xls)};DBQ=" + QString("sht.xlsx"));
if(db.open())
{
    QSqlQuery query("select * from [" + QString("Sheet1") + "$]");
    // Select range, place A1:B5 after $
    while (query.next())
    {
        QString column1= query.value(0).toString();
        qDebug() << column1;
    }
}
else {
    qDebug() << db.lastError().text();
}

And for some reason it throws an error:

"[Microsoft][ODBC Driver Manager] No data source found and no QODBC3 default driver specified: Unable to connect"

I've already broken my brain, why. Does anyone have any idea?

Answer 1

You need the full path to the xlsx file. The driver name must exactly match the name in ODBC.
You also need a working directory. In general, I understand something like
or

DBQ=c:\temp\dexcel003.xlsx;DefaultDir=c:\temp;Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DriverId=1046;FIL=Excel 12.0;MaxBufferSize=2048;PageTimeout=5;ReadOnly=0;

Answer 2

Do you have a driver?