Excel to PDF conversion

Hi,

There is no straight forward solutions for this, but we can achieve this in multi step approach. This might not be the best solution, but if you want you can try.

• First read the excel file data using readExcelSheet() function and save this data in kay value pair format using map function or save into a temporary display CDT
• Construct a XML data using above saved data. (You need to pass this data to process variable).
• Create a DOCX template (This template contains tabular configuration)   
  • See the following available plugins to see how we can generate documents using DOCX templates
    • https://community.appian.com/b/appmarket/posts/dynamic-document-generator
    • https://community.appian.com/b/appmarket/posts/advanced-document-templating
• Now generate a document using above template and the data you saved in process variable
• After generating the document you convert this document to PDF using PDF From DOCX smart service

Note: Since you have more then 50 columns I am not how the final data rendered in document, but you can try if it meets your requirement. 

I cant find readExcelSheet() function, can you explain how can i used that ?

Hi

This function will comes with excel tools plugin, you need to deploy this plugin into your environment. you can find more details about this plugin here

Hi

This function will comes with excel tools plugin, you need to deploy this plugin into your environment. you can find more details about this plugin here