Free libraries to work with Excel

Posted by Danil Gholtsman on Programmers See other posts from Programmers or by Danil Gholtsman
Published on 2013-10-18T03:31:55Z Indexed on 2013/10/18 4:11 UTC
Read the original article Hit count: 233

Filed under:
|
|
|

I got some excel files, I need to read data from it and upload data to some database (I need to use firebird, but whatever). Right now I use <QAxObject> from Qt and code look like

QAxObject* excel = new QAxObject("Excel.Application"); //pointer to excel 
//excel->setProperty("Visible", false); 
QAxObject* workbooks = excel->querySubObject("WorkBooks"); //get pointer to booklist
workbooks->dynamicCall("Open (const QString&)", QString("C:\\databases\\test.xls")); //opening file, getting pointer to booklist
QAxObject* workbook = excel->querySubObject("ActiveWorkBook"); 
QAxObject* worksheets = workbook->querySubObject("WorkSheets"); 

etc.

The problem is that this way on users PC there must be installed Excel.

Is there exists some free C++ libraries to work with *.xls, *.xlsx files without Excel installed?

© Programmers or respective owner

Related posts about c++

Related posts about libraries