i want to export qlikview objects to excel/powerpoint

[udaya_kumar]

hi,

i want to export qlikview objects to excel/powerpoint on button click. But the object exported should work as if it is in QlikView.

Means if i click button, then the table or chart should change its data in excel/powerpoint.

Is it possible to do this in anyway? either using macros or any other method?

[sureshbaabu]

Hello,

I was not able to make that as default.

Could you please help me fixing the following issue?

I have 2 objects, one on 1st sheet and 2nd on the next sheet.

I was able to export the object on 1st sheet to the ppt and could not export the 2nd one, Beacuse it was not the  Active sheet.

I tried the following from http://community.qlik.com/message/246942#246942

ActiveDocument.ActivateSheetByID "SH01"

It may also be necessary to restore the object (if it is minimized) with something like this:

ActiveDocument.GetSheetObject("CH03").Activate

But no Luck!!! Did you happen to try anything like this?

[Anonymous]

Hi..i have a similar request to export objects from both active and inactive sheets in a LAN drive. There are no minimized objects in my sheet. My active sheet is SH07. I have tried using the below lines but this exports only SH07 object and not SH06 (inactive sheet)

ActiveDocument.ActivateSheetbyId "SH06"
ActiveDocument.Sheets("SH06").Activate
ActiveDocument.Sheets("SH06").SheetObjects("CH254").ExportBitmapToFile "C:\Users\43862460\Reports\WIP\TestImages\Aging" & ".jpg"

ActiveDocument.ActivateSheetbyId "SH07"
ActiveDocument.Sheets("SH07").Activate
ActiveDocument.Sheets("SH07").SheetObjects("CH257").ExportBitmaptoFile "C:\Users\43862460\Reports\WIP\TestImages\SLA" & ".jpg"

Did you find any solution to this?

[Anonymous]

or for that matter only the last Activate sheet id statement. If I swap the statements of export of active and inactive sheets it just exports the last object and not but the objects..Any clues on how to proceed?

ActiveDocument.ActivateSheetbyId "SH07"
ActiveDocument.Sheets("SH07").Activate
ActiveDocument.Sheets("SH07").SheetObjects("CH257").ExportBitmaptoFile "C:\Users\43862460\Reports\WIP\TestImages\SLA" & ".jpg"

ActiveDocument.ActivateSheetbyId "SH06"
ActiveDocument.Sheets("SH06").Activate
ActiveDocument.Sheets("SH06").SheetObjects("CH254").ExportBitmapToFile "C:\Users\43862460\Reports\WIP\TestImages\Aging" & ".jpg"