Export section to PPT
I have a requirement where I have to export the section data to PPT. Can anyone let me know how can we achieve this in Pega.
FYI:I have already exported the section to PDF through HTMLTOPDF activity and hence i already have HTMLstream and markup for that section ready .
Pegasystems Inc.
GB
There is no OOTB mechanism for creating Powerpoint files from PRPC.
However: PRPC does ship with the Apache POI library - which has some support for creating PPT/PPTX files.
The following (out-of-guardrails) Java Step will create a "Hello Pega !" PPT using Apache POI file.
org.apache.poi.hslf.usermodel.HSLFSlideShow ppt=new org.apache.poi.hslf.usermodel.HSLFSlideShow();
org.apache.poi.hslf.usermodel.HSLFSlide slide=ppt.createSlide();
org.apache.poi.hslf.usermodel.HSLFTextBox shape = slide.addTitle();
shape.setText("Hello Pega !");
try {
org.apache.commons.io.output.ByteArrayOutputStream bos=new org.apache.commons.io.output.ByteArrayOutputStream();
ppt.write(bos);
ppt.close();
tools.sendFile(bos.toByteArray(), "mylovelypowerpoint.ppt", false, null, true);
}
catch(Exception e) { throw new PRRuntimeException(e); }
But I think it would be a bit more tricky to export your SECTIONs to a PPT; you would (probably - I don't know the Apache POI PPT API well enough to say for sure) need to convert your Section HTML to show it in the PPT.
Maybe you could *screenshot* your Sections (somehow) and include them in PPT slides ?
Cognizant Technology Solutions
US
I converted section to HTMLStream and tried to pass it to slide show but it doesnt work..Is there any other way..?
Pegasystems Inc.
GB
This is out of scope for a PRPC forum really; but some ideas:
I'm not sure whether PPT allows you just to embed HTML.
You might have to render the HTML to an image somehow: and then embed that image into a PPT slide.
Some suggestions here on how to do that: https://stackoverflow.com/questions/10721884/render-html-to-an-image
Bear in mind that renderers may not be 100% accurate; especially considering a lot of PRPC UIs are dynamically built these days (that is: Javascript is used to populate and draw the UI).
Cognizant Technology Solutions
US
Thank you for your quick response John... Previous code that you have shared creates the PPT with one empty slide..
I think this code is for version 7.2.2 but i am working on 7.1.8.. as the textbox class that we are invoking pega doesnt except that...
Can you please help me with that?
Thanks
Alka
Capgemini
IN
Modified code by John, the below is supported in 7.1.8
Modified code by John, the below is supported in 7.1.8
com.pega.apache.poi.xslf.usermodel.XMLSlideShow ppt = new com.pega.apache.poi.xslf.usermodel.XMLSlideShow();
//getting the slide master object
com.pega.apache.poi.xslf.usermodel.XSLFSlideMaster slideMaster = ppt.getSlideMasters()[0];
//select a layout from specified list
com.pega.apache.poi.xslf.usermodel.XSLFSlideLayout slidelayout = slideMaster.getLayout(com.pega.apache.poi.xslf.usermodel.SlideLayout.TITLE_AND_CONTENT);
//creating a slide with title and content layout
com.pega.apache.poi.xslf.usermodel.XSLFSlide slide = ppt.createSlide(slidelayout);
//selection of title place holder
com.pega.apache.poi.xslf.usermodel.XSLFTextShape title = slide.getPlaceholder(0);
//setting the title in it
title.setText("Introduction");
//selection of body placeholder
com.pega.apache.poi.xslf.usermodel.XSLFTextShape body = slide.getPlaceholder(1);
//clear the existing text in the slide
body.clearText();
//adding new paragraph
body.addNewTextParagraph().addNewTextRun().setText("this is my first slide body");
try {
org.apache.commons.io.output.ByteArrayOutputStream bos=new org.apache.commons.io.output.ByteArrayOutputStream();
ppt.write(bos);
bos.close();
String result=tools.sendFile(bos.toByteArray(), "mylovelypowerpoint.ppt", false, null, true);
}
catch(Exception e) { throw new PRRuntimeException(e); }