Excel and Qt

[antialias]

Here's some code that can get you started. I must stress, that I don't fully understand it, since I copied and pasted it from somewhere else - and then started to screw around with it. So don't ask me to explain in depth. The comments in here are what I THINK happens.

I still need to create a QAxWidget for some reason, even though I only want to read and not display the excel file. If anyone knows how I can get around using a QApplication and a QAxWidget object and still have this work: please let me know.

#include <qaxobject>
#include <qaxwidget>
#include <qapplication>
 
int main(int argc, char *argv[])
{
QString strVal;
const char* cp = "Range(E11)";
 
QApplication a(argc, argv);
QAxWidget excel("Excel.Application");   
 
// because I want to read the file - not display it.
excel.setProperty("Visible", false);
 
QAxObject *workbooks = excel.querySubObject("WorkBooks");
workbooks->dynamicCall("Open (const QString&)", QString("e:/tmp/test3.xls"));
QAxObject *workbook = excel.querySubObject("ActiveWorkBook");
 
// I need data from the 2nd worksheet (worksheets are numbered starting from 1)
QAxObject *worksheet = workbook->querySubObject("Worksheets(int)", 2);
 
// Read fom the second worksheet the contents of cell E11
QAxObject *range = worksheet->querySubObject(cp);
strVal = range->property("Value").toString();
 
// close the excel file
excel.dynamicCall("Quit (void)");
 
return(0);
}

#include <qaxobject>
#include <qaxwidget>
#include <qapplication>

int main(int argc, char *argv[])
{
QString strVal;
const char* cp = "Range(E11)";

QApplication a(argc, argv);
QAxWidget excel("Excel.Application");   

// because I want to read the file - not display it.
excel.setProperty("Visible", false);

QAxObject *workbooks = excel.querySubObject("WorkBooks");
workbooks->dynamicCall("Open (const QString&)", QString("e:/tmp/test3.xls"));
QAxObject *workbook = excel.querySubObject("ActiveWorkBook");

// I need data from the 2nd worksheet (worksheets are numbered starting from 1)
QAxObject *worksheet = workbook->querySubObject("Worksheets(int)", 2);

// Read fom the second worksheet the contents of cell E11
QAxObject *range = worksheet->querySubObject(cp);
strVal = range->property("Value").toString();

// close the excel file
excel.dynamicCall("Quit (void)");

return(0);
}

To copy to clipboard, switch view to plain text mode 

[marcvanriet]

Hi antialias,

Thanks for the sample code. It worked almost right away. Just had to add "LIBS += qaxcontainer.lib" to my .pro file, and then use the full path name to my excel file.

For the QAxWidget : you can just use a QAxObject instead of QAxWidget.

For skipping QApplication, I don't know for sure. A 'console application' doesn't need QApplication. From "C++ Programming with Qt4' : "... since this is a console application, it has a slightly different .pro file from those we have seen for GUI applications. We only link against QtCore since we don't use any GUI fucntionallity. Then we specify that we want to enable console output on windows and that we don't want the application to live in a bundle on maxosx" and they give the following .pro file :
TEMPLATE = app
QT = core
CONFIG += console
CONFIG -= app_bundle
SOURCES = ....... your sources

By the way : if something goes wrong in the calls to the QAxObject (like specifying a wrong filename), you get detailed error information in the application output window of QtCreator. I hope you get this output too, because it helps a lot.

Best regards,
Marc

[marcvanriet]

Hi antialias,

Thanks for the sample code. It worked almost right away. Just had to add "LIBS += qaxcontainer.lib" to my .pro file, and then use the full path name to my excel file.

For the QAxWidget : you can just use a QAxObject instead of QAxWidget.

For skipping QApplication, I don't know for sure. A 'console application' doesn't need QApplication. From "C++ Programming with Qt4' : "... since this is a console application, it has a slightly different .pro file from those we have seen for GUI applications. We only link against QtCore since we don't use any GUI fucntionallity. Then we specify that we want to enable console output on windows and that we don't want the application to live in a bundle on maxosx" and they give the following .pro file :
TEMPLATE = app
QT = core
CONFIG += console
CONFIG -= app_bundle
SOURCES = ....... your sources

By the way : if something goes wrong in the calls to the QAxObject (like specifying a wrong filename), you get detailed error information in the application output window of QtCreator. I hope you get this output too, because it helps a lot.

Best regards,
Marc

[antialias]

For the QAxWidget : you can just use a QAxObject instead of QAxWidget.

When I try that it crashes in this line.

workbooks->dynamicCall("Open (const QString&)", QString("e:/tmp/test3.xls"));

workbooks->dynamicCall("Open (const QString&)", QString("e:/tmp/test3.xls"));

To copy to clipboard, switch view to plain text mode 

with a Null pointer exception.
If I leave out the QApplication it doesn't compile at all (even though my app is a console application)

I'm working with Visual Studio 2010 Express (just using Qt classes/libs but not making a GUI for this project) - so I don't have a pro-File. The debug information is somewhat limited, too :-(

But it works well enough so I'll move on to other things...

[Ginsengelf]

Hi, for console applications there is QCoreApplication.

Ginsengelf