Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to export qlikview sheet to power point

Hi All

Please tell me, Is it possible to export one  sheet in a  qvw file to power point..

Thanks

Ganesh

26 Replies
vikasmahajan

see this https://community.qlik.com/thread/212111

vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
kkkumar82
Specialist III
Specialist III

Other than macros you can use tools like Nprinting

Not applicable
Author

Actually, Do we need license to use N-Printing?? I have licensed Desktop client ,

Is NPrinting is again a different Application or can we use it in Personal Edition?

Thanks

Ganesh

Not applicable
Author

with this, can we export entire sheet or some of the objects in sheet?

actulally, i have no knowledge of Macros, I am unable to understand anything in the link you provided

Thanks

vikasmahajan

check with this QlikView NPrinting 16 Tutorials by Subject

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Anonymous
Not applicable
Author

kkkumar82
Specialist III
Specialist III

Nprinting is a seperate license, to use nprinting client you have to request Qlik for trial licenses and remember to work with the different options of Nprinting we require a licensed Qlikview Desktop.

Its all about licenses

Not applicable
Author

Yeah, than i wont go for N-Printing, I dont think we buy N-Printing License in near future

Thanks

Ganesh

Anonymous
Not applicable
Author

by using the code and change the objectids than

at macros

Sub ExportPPT

ActiveDocument.ActiveSheet.FitZoomToWindow

Set objPPT = CreateObject("PowerPoint.Application")

objPPT.Visible = True

Set objPresentation = objPPT.Presentations.Add

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

   '     ActiveDocument.ActiveSheet.CopyBitmapToClipboard

  ActiveDocument.GetSheetObject("CH19").CopyBitmapToClipboard

        PPSlide.Shapes.Paste

       

       

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

   '     ActiveDocument.ActiveSheet.CopyBitmapToClipboard

  ActiveDocument.GetSheetObject("CH14").CopyBitmapToClipboard

        PPSlide.Shapes.Paste

       

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

   '     ActiveDocument.ActiveSheet.CopyBitmapToClipboard

  ActiveDocument.GetSheetObject("LB20").CopyBitmapToClipboard

        PPSlide.Shapes.Paste

       

       

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

   '     ActiveDocument.ActiveSheet.CopyBitmapToClipboard

  ActiveDocument.GetSheetObject("LB17").CopyBitmapToClipboard

        PPSlide.Shapes.Paste

       

      

Set PPSlide = Nothing

Set PPPres = Nothing

End sub

and give the request module is system access a

and current local security is allow system access

and create the button and go to the action and select the external and select the macro and give the name what available at the macro code  and run the code and get the output