topic export QlikView Objects to *.BMP in QlikView

export QlikView Objects to *.BMP

thierrytt1102 — Mon, 01 Aug 2011 14:46:58 GMT

Hello,

I have a problem here trying to export QlikView Objects to images.

I developped this macro:

sub Exportation

ActiveDocument.ClearAll

DocSheet = ActiveDocument.Sheets("Sheet").Activate

Objects = ActiveDocument.ActiveSheet.GetSheetObjects

FOR i = lBound(Objects) TO uBound(Objects)

SET obj = Objects(i)

obj.ExportBitmapToFile "C:\ "&i&".bmp"

end sub

It works fine but I'd like to:

1. take the objects of every sheets

2. rename the file with the name of the object.

Does anyone can help me?

Thanks a lot.

export QlikView Objects to *.BMP

danielrozental — Tue, 02 Aug 2011 01:20:16 GMT

you can go through all sheets like this

for j= 0 to ActiveDocument.NoOfSheets - 1 set s=ActiveDocument.Sheets(j)

and you can go through all objects in the sheet like this

Objects = s.GetSheetObjects

For i = lBound(Objects) To uBound(Objects)

If you want to use the ID like this, or the title

Object.GetObjectId

Object.GetProperties.Title.v

Re: export QlikView Objects to *.BMP

Tue, 02 Aug 2011 03:47:21 GMT

Hi,

Please see if the attached sample can help you.

Cheers.

export QlikView Objects to *.BMP

thierrytt1102 — Tue, 02 Aug 2011 07:22:57 GMT

Dear.

Thnks for yout file but I cannot open it as I'm using the Personal Edition. Could you show me the code? Thank you very much

Re: export QlikView Objects to *.BMP

Tue, 02 Aug 2011 07:25:37 GMT

Hi,

Please find the macro, call this on the click of a button:

sub Exportation()

ActiveDocument.ClearAll

for j= 0 to ActiveDocument.NoOfSheets - 1

ActiveDocument.ActivateSheet j

set s=ActiveDocument.Sheets(j)

Objects = s.GetSheetObjects

FOR i = 0 TO uBound(Objects)

SET obj = Objects(i)

obj.ExportBitmapToFile "C:\Temp\"& replace(obj.GetCaption.Name.v," ","") & ".bmp"

ActiveDocument.ActivateSheet 0

end sub

Cheers.

export QlikView Objects to *.BMP

thierrytt1102 — Tue, 02 Aug 2011 08:10:57 GMT

Thank you BlackRockS

However Qlikview crashes when executing your code...

Do you have an explanantion as you code seems to be ok?

Thanks

Re: export QlikView Objects to *.BMP

Tue, 02 Aug 2011 08:20:41 GMT

Hi,

I am not sure why it is not working, but for me it works fine.

Cheers.

export QlikView Objects to *.BMP

thierrytt1102 — Tue, 02 Aug 2011 08:48:28 GMT

Hi,

This is strange indeed. I made a button "macro" in the first sheet and the result is different when executed from the third... same name, same macro.

I took the qlikview example of "films". Normally it has to display more than 50 objects... I have only 11.

Hope you checked the integrity out as well.

Cheers.

export QlikView Objects to *.BMP

Mon, 21 Nov 2011 10:26:31 GMT

Hi All,

I am trying to use an export macro to get images of specific charts into "BMP" format in order to use them to update links on a PowerPoint presentation.

The macro does work, but there instances where QlikView does not respond quick enough and a blank image gets exported.

Heres the code I am currently using in my macro:

set APP = ActiveDocument.GetApplication

set c=ActiveDocument.GetSheetObject("CH158")

APP.WaitForIdle

c.Restore

APP.WaitForIdle

APP.Sleep 1000

ActiveDocument.ClearAll

APP.WaitForIdle

APP.Sleep 1000

ActiveDocument.RecallDocBookmark "Slide2"

APP.WaitForIdle

APP.Sleep 1000

set obj = ActiveDocument.GetSheetObject("CH158")

obj.WriteToFile "C:\Insight\PPT Images\MetCash\" & "001 National - National - LAD’s by Manufacturer Share.bmp", 0

APP.Sleep 1000

APP.WaitForIdle

It does this for about 10 images. Majority of them are fine, but there are a few that turn up blank now and again.

Any suggestions?

Re: export QlikView Objects to *.BMP

Tue, 22 Nov 2011 04:15:34 GMT

Hi,

I have tested the above macro script for 25 times and it could export the image all the 25 times with out any problem.

How big is the qlikview file? Do you have too many data points in the chart you are trying to export?

Please let me know further details.

Cheers.

Re: export QlikView Objects to *.BMP

Tue, 22 Nov 2011 09:47:55 GMT

Hey thanks for the response.

I am using stacked bar charts so there quite a number data points. An average of around 30 on each chart.

I've tried this code and it seems to be working correctly thus far:

set APP = ActiveDocument.GetApplication

set c=ActiveDocument.GetSheetObject("CH158")

APP.WaitForIdle

APP.Sleep 1000

c.Restore

APP.WaitForIdle

APP.Sleep 1000

ActiveDocument.ClearAll

APP.WaitForIdle

APP.Sleep 1000

ActiveDocument.RecallDocBookmark "Slide2"

APP.WaitForIdle

APP.Sleep 1000

ActiveDocument.GetSheetObject("CH158").ExportBitmapToFile "C:\Insight\PPT Images\MetCash\" & "001 National - National - LAD’s by Manufacturer Share.bmp"