Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
udaya_kumar
Specialist
Specialist

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?

13 Replies
IAMDV
Luminary Alumni
Luminary Alumni

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

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

Not applicable

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

IAMDV
Luminary Alumni
Luminary Alumni

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

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

Not applicable

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

IAMDV
Luminary Alumni
Luminary Alumni

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

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

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