Qt 6.11 is out! See what's new in the release
blog
How to set select range when read excel by using ODBC
General and Desktop
1
Posts
1
Posters
686
Views
1
Watching
-
Hello~ I need to read the excel by ODBC then
"I followed this article":http://qt-project.org/wiki/Handling_Microsoft_Excel_file_formatAnd i tried this
@ QSqlQuery query("select * from [" + QString("Sheet1") + "$]"); // Select range, place A1:B5 after $@
read all excel file.but this not work. Any body know how to the select range?
@ QSqlQuery query("select * from [" + QString("Sheet1") + "$A1:B5]"); // Select range, place A1:B5 after $@