PDA

View Full Version : Can Qt deal with Excel?


Patrick Sorcery
4th January 2013, 02:35
I mean... for example, write something to some locations of the MS Excel worksheet file.

Are there some ways to do this?
ChrisW67
4th January 2013, 06:30
Yes. ActiveQt or the Excel ODBC driver through QtSql
Patrick Sorcery
9th January 2013, 00:41
Yes. ActiveQt or the Excel ODBC driver through QtSql

ActiveQt seems not free... & are there some simple examples of Excel ODBC? Thanks!
ChrisW67
9th January 2013, 05:48
ActiveQt is a standard part of the Qt libraries and has been on an open license for at least a couple of years. All the ActiveQt source code I can see has a BSD header.

To use the ODBC interface you treat an Execl spreadsheet as if it were a table through Qt SQL with the ODBC plugin. You need to provide an Excel ODBC connection string (http://www.connectionstrings.com/excel#microsoft-excel-odbc-driver) or suitable DSN to QSqlDatabase::setDatabaseName(). I've never done it in anger so I don't have a canned example.