2

I'm using Qt activex (QAxObject) in order to read/write excel files.

QAxObject* excel = new QAxObject( "Excel.Application", 0 );
QAxObject* workbooks = excel->querySubObject( "Workbooks" );
QAxObject* workBook = workbooks->querySubObject("Open(const QString&)", path);
QAxObject* sheets = workBook->querySubObject( "Worksheets" );
QAxObject* sheet1 = sheets->querySubObject( "Item( int )", 1 );
QAxObject* sheet2 = sheets->querySubObject( "Item( int )", 2 );
//....

We know that this mechanism uses excel itself and is not working on computers that excel is not installed.

If the code runs on such computers (without excel installed), then, the program crashes. How can I detect in the code that excel is not installed on PC?

Mosi
  • 1,178
  • 2
  • 12
  • 30

1 Answers1

5

You check if workbooks is NULL pointer. As a rule of thumb, you may want to check if excel is null pointer before using it.

QAxObject* excel = new QAxObject( "Excel.Application", 0 );

if ( excel )
{
     QAxObject* workbooks = excel->querySubObject( "Workbooks" );

     if ( workbooks )
     {
           QAxObject* workBook = workbooks->querySubObject("Open(const QString&)", path);
           QAxObject* sheets = workBook->querySubObject( "Worksheets" );
           QAxObject* sheet1 = sheets->querySubObject( "Item( int )", 1 );
           QAxObject* sheet2 = sheets->querySubObject( "Item( int )", 2 );

           ...
m. c.
  • 867
  • 5
  • 12
  • `NULL` is a C thing. In C++, use `nullptr`, or `0` if you must maintain compatibility with pre-C++11 compilers. In most projects, though, the `if (ptr) ` test is an idiom as well. You might also wish not to start a new block on each test, but return from the function whenever a test fails. – Kuba hasn't forgotten Monica Dec 19 '16 at 21:30