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

Originally Posted by ChrisW67

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 or suitable DSN to QSqlDatabase::setDatabaseName(). I've never done it in anger so I don't have a canned example.