Generating embedded charts via Qt ActiveX

alizadeh91

@mrjj But still having problem with adding new embedded chart!!!

mrjj

Did you try the test code ?.

It inserts embedded for me.

QAxObject* test = workbook->querySubObject("ActiveSheet");
QAxObject* charts = test->querySubObject("ChartObjects");
QList<QVariant> f; f << 200 << 400 << 200 << 200;
charts->dynamicCall("Add(int, int, int, int)", f );

I didnt check if
("ChartObjects(int)",1)->querySubObject("Chart"); will give you that.

From docs, the Add should return the chart object but I could not get it to cast to
QAxObject* .

alizadeh91

@mrjj I've changed sheet2->querySubObject("ChartObjects"); to sheet2->querySubObject("ChartObjects()"); and it worked

mrjj

Super :)
oh it must have "()" on.
The syntax is pretty funky via the automation server.
Good work.