How to set select range when read excel by using ODBC
-
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 $@