Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Thanx DV for ur response.................. What resolution size we should use for this?............we r using 1000* 280 resolution..........
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
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
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
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
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
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
The qlikview application works but it is exporting to PPT as a duplicated slide. How can we export a qlikview application of 5 tabs?