Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select a graphic inside a container

Hello,

I'm trying to export graphics into a powerpoint document from a Qlikview application (*.qvw). My different graphics are on different sheet, and include in some container. I don't arrive to selected the graphics inside a container (using ActiveDocument.GetSheetObject("CHxxx").Activate command). It's work correctly if graphics are outside the container.

I don't arrive to create a link to those graphic too, using Copy/Paste Sheet Object as Link Qlik function.

Did you have some information about this feature ?

Best regards.

Jean

2 Replies
beck_bakytbek
Master
Master

Hi Jean,

check this: Exporting objects in Containers

i hope that helps

beck

Not applicable
Author

Dear Beck,

It's seems working for a table, not for graphic. I've the following code :

  Set ContainerObj = ActiveDocument.GetSheetObject("CT01") 'Container ID

  Set ContProp=ContainerObj.GetProperties   

  SheetObj=Array("CH184","CH79","CH80","CH85")                    'Chart ID's

  for i=0 to UBound(SheetObj)

 

    Set PPSlide = objPresentation.Slides.Add(2,11)

   

    Set obj = ActiveDocument.GetSheetObject(SheetObj(i))

    obj.CopyTableToClipboard True

    'obj.CopyBitmapToClipboard True

   

    PPSlide.Shapes.Paste 

    PPSlide.Shapes(PPSlide.Shapes.Count).Top = 150 'This sets the top location of the image 

    PPSlide.Shapes(PPSlide.Shapes.Count).Left = 15 'This sets the left location 

    PPSlide.Shapes(PPSlide.Shapes.Count).Width = 240 

    PPSlide.Shapes(PPSlide.Shapes.Count).Height = 250 

  Next   

It seems working with obj.CopyTableToClipboard True, but it doesn't work with obj.CopyBitmapToClipboard True

Did you have an idea ?

Best regards.

Jean