topic Re: How to export QlikView Sheet as an image to PowerPoint? in QlikView

How to export QlikView Sheet as an image to PowerPoint?

udaya_kumar — Wed, 22 Feb 2012 10:40:00 GMT

Hi all,

i am able to export the sheet as an image to powerpoint,

but the problem is that, the image is getting truncated after it is exported.

what could be the problem?

can anyone help me in this issue?

Thanks in advance

the code is given below

sub exportppt

Set objPPT = CreateObject("PowerPoint.Application")

objPPT.Visible = True

Set objPresentation = objPPT.Presentations.Add

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

ActiveDocument.ActiveSheet.CopyBitmapToClipboard

PPSlide.Shapes.Paste

Set PPSlide = Nothing

Set PPPres = Nothing

Set PPApp = Nothing

End Sub

so it is exporting, but the image is not coming fully, it is getting truncated.

how we can rectify this problem?

Re: How to export QlikView Sheet as an image to PowerPoint?

IAMDV — Wed, 22 Feb 2012 10:47:24 GMT

Hi,

It works for me. What is the screen resolution and are youusing fit to window option? It will be nice if you can post the QV document.

Cheers - DV

How to export QlikView Sheet as an image to PowerPoint?

Wed, 22 Feb 2012 10:57:19 GMT

Thanx DV for ur response.................. What resolution size we should use for this?............we r using 1000* 280 resolution..........

How to export QlikView Sheet as an image to PowerPoint?

Mon, 27 Feb 2012 09:19:46 GMT

Hello all

THis is really great as I manage to export the picture to PPT or Excel on my QlikView.

I still have a question.

Is there a way to export without taking into account the size of MY screen.

I'm using QlikView publisher and would like to export defining a specific size of the sheet view to export.

Thanks again and waiting for you

regards

Jerome

Re: How to export QlikView Sheet as an image to PowerPoint?

IAMDV — Mon, 27 Feb 2012 10:27:03 GMT

Hi Jerome,

If you don't want to export the entire sheet then you can try to export the chart object. I mean you can loop through each chart object in each sheet and export them to PPT. Is this what you are looking for?

Thanks,

Re: How to export QlikView Sheet as an image to PowerPoint?

Mon, 27 Feb 2012 11:16:54 GMT

Hello

Thanks a lot for your quick answer. I already did that but reformatting all the objects are quite long…

Though I’d like to build the dashboard in QV and export as is in a file (or ppt). I’m currently using the ActiveDocument.ActiveSheet.ExportBitmapToFile ExportPath & "Dashboard_"& SelectedField &".png"

Can you help?

thanks

How to export QlikView Sheet as an image to PowerPoint?

Mon, 27 Feb 2012 12:35:13 GMT

Let me rephrase a bit.

I'd like to build my whole dashboard in a sheet and export the overall sheet as image without taking care of my current resolution but in best case, entering the requesed part of sheet to be extracted.

regards

Re: How to export QlikView Sheet as an image to PowerPoint?

IAMDV — Tue, 28 Feb 2012 15:41:49 GMT

Hi Jerome,

Thanks for explaining in detail. Now I have understood the requirement. There is no built-in feature to take customize the screenshot selection. However, I have some ideas of integrating as extension objects with an open source screenshot application with QlikView. I'll experiment with this and I'll update you if I can get this working.

Meanwhile, if other community users might have better ideas.

Good luck!

Cheers - DV

Re: How to export QlikView Sheet as an image to PowerPoint?

Tue, 28 Feb 2012 15:56:23 GMT

Thanks, waiting from you then.

In the meantime, 2 solutions :

Export al objects

Build several sheets based on the standard screen resolution to export.

Cheers

How to export QlikView Sheet as an image to PowerPoint?

Tue, 28 Feb 2012 21:37:14 GMT

The qlikview application works but it is exporting to PPT as a duplicated slide. How can we export a qlikview application of 5 tabs?

Re: How to export QlikView Sheet as an image to PowerPoint?

Tue, 28 Feb 2012 21:38:07 GMT

The qlikview application works but it is exporting to PPT as a duplicated slide. How can we export a qlikview application of 5 tabs?

Re: How to export QlikView Sheet as an image to PowerPoint?

Tue, 27 Mar 2012 09:17:50 GMT

Hi DV,

I am looking for the same functionality as Jerome. Have you further developed yoour ideas since the discusison with Jerome. I mean your ideas on exporting to ppt ignoring the screensize that the dashboard happens to be at?

Regards,

MarcD.

Re: How to export QlikView Sheet as an image to PowerPoint?

jumiprado — Fri, 10 Oct 2014 17:54:40 GMT

hey guys! how are you.

I want to create a powerpoint from some differents qlikview objects. I could creat the macro wich create the ppt and paste the objects but i have the following questions:

How can i create the ppt with a specific name?

How can i put one object per slide ?

How can i put two specific objects in a specific slide?

here i paste the macro. THANKS A LOT!!!

Sub ppt

'An array with the objects you want to export to powerpoint

Dim myArray(4)

myArray(0) = "CH09"

myArray(1) = "TX22"

myArray(2) = "TX23"

myArray(3) = "TX31"

'Create ppt object

Set objPPT = CreateObject("PowerPoint.Application")

objPPT.Visible = True

Set objPresentation = objPPT.Presentations.Add

'Apply a template if you want one

'objPresentation.ApplyTemplate _

' ("C:\mytemplate.potx")

'For each object in the array create a new slide and paste it.

For each item in myArray

' Set MySheet = ActiveDocument.GetSheet(i)

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

' ActiveDocument.ActiveSheet.CopyBitmapToClipboard

ActiveDocument.GetSheetObject("CH09").CopyBitmapToClipboard

ActiveDocument.GetSheetObject("TX22").CopyBitmapToClipboard

with PPSlide.Shapes.Paste

.Left = 90

.top = 50

.width=50

.height=90

end with

ActiveDocument.GetSheetObject("TX31").CopyBitmapToClipboard

with PPSlide.Shapes.Paste

.Left = 150

.top = 350

.width=20

.height=20

end with

ActiveDocument.GetSheetObject("TX23").CopyBitmapToClipboard

with PPSlide.Shapes.Paste

.Left = 150

.top = 350

.width=50

.height=90

end with

'Clean up

Set PPSlide = Nothing

Set PPPres = Nothing

Set PPApp = Nothing

End Sub

Re: How to export QlikView Sheet as an image to PowerPoint?

Tue, 11 Nov 2014 11:57:07 GMT

Hi Uday,

This macro copy the sheet into an image and then it fits this image to the powerpoint slide size. It will be done as much sheets as your document has. (See the Shape instruction)

sub ExportarPPT

ActiveDocument.ActiveSheet.FitZoomToWindow

ActiveDocument.ActiveSheet.ApplyZoomToAllSheets

Set PPApp = CreateObject("PowerPoint.Application")

PPApp.Visible = True

Set PPres = PPApp.Presentations.Add

PPSlideNo = 1

For i = 0 to ActiveDocument.NoOfSheets - 1

Set PPSlide = PPres.Slides.Add(PPSlideNo,1)

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.ActiveSheet.CopyBitmapToClipboard

PPSlide.Shapes.Paste

with PPSlide.Shapes(PPSlide.Shapes.Count)

.left = 0

.top = 20

.width =720

end with

activedocument.nexttab

PPSlideNo = PPSlideNo + 1

PPres.SaveAs "C:\Presentation1.ppt"

PPres.Close

PPApp.Quit

Set PPSlide = Nothing

Set PPPres = Nothing

Set PPApp = Nothing

End Sub