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
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