Merge Documents

PDF tools plugin merges only multiple pdf's into single pdf

For the DOCX, you could use this component to convert it to PDF first then merge using PDF Tools.(forum.appian.com/.../summary),

We are using this plugin Christine with some customization which caters for the size of pdf's & table of contents, but the issue here is the result PDF from this plugin "DynamicDocumentGen-1.4.1.jar" needs to have some different flavoured documents(xls/docx/pdf) merged into it. Thats where am looking to see if we have anything already built in our shared resources.

@naveena113 I agree with @christineh, however if this does not fulfills your requirement then you can follow the below mention Steps:

1. Create a Smart Service which can convert xls to PDF using iText and Apache POI API
2. Use this smart service to store the returned Document of type PDF
3. Use DocsToPDF smart service to convert the docx file and capture it's returned document
4. Use Merge PDF Smart Service by passing these all there PDF document as an array to it's input, which will return you a single PDF



here the most challenging part could be Creating a Custom Smart Service mention at Step-1
You need to download following jar files to build to make this work

======================================================
dom4j-1.6.1.jar
itextpdf-5.4.0.jar
log4j-1.2.17.jar
poi-3.9.jar
poi-ooxml-3.5-beta5.jar
poi-ooxml-3.6-20100309.jar
poi-ooxml-schemas-3.7-beta1.jar
xmlbeans-2.5.0.jar
xmlbeans-xmlpublic-2.4.0.jar
=====================================================

And then follow the attached Java code and convert the code according to your requirement.
Also attached the output of the attached Java file, which is generating Excel to PDF successfully.

Hope this will help you to build the Smart Service Successfully.

ExcelToPDF.java

thanks Alok, Christine