Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

udaya_kumar
Valued Contributor

How to export QlikView Sheet as an image to PowerPoint?

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?

Tags (2)
13 Replies
dvqlikview
Honored Contributor II

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

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

Not applicable

How to export QlikView Sheet as an image to PowerPoint?

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

Not applicable

How to export QlikView Sheet as an image to PowerPoint?

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

dvqlikview
Honored Contributor II

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

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,

DV

Not applicable

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

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

Highlighted
Not applicable

How to export QlikView Sheet as an image to PowerPoint?

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

dvqlikview
Honored Contributor II

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

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

Not applicable

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

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

Not applicable

How to export QlikView Sheet as an image to PowerPoint?

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

Community Browser