topic Re: Select a graphic inside a container in QlikView

Select a graphic inside a container

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Select a graphic inside a container

beck_bakytbek — Fri, 26 Aug 2016 08:36:17 GMT

Hi Jean,

check this: Exporting objects in Containers

i hope that helps

beck

Re: Select a graphic inside a container

Fri, 26 Aug 2016 13:57:20 GMT

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

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

Did you have an idea ?

Best regards.

Jean