Skip to main content
debasishj0002
April 29, 2022
Question

Excel to PDF conversion

  • April 29, 2022
  • 3 replies
  • 0 views

Hi Everyone,

I have a excel file with more than 50 columns of data and I need to convert that excel to PDF. how can I do that ?

    3 replies

    Inspiring
    April 30, 2022

    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)   
    • 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. 

    debasishj0002
    May 4, 2022

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

    Inspiring
    May 4, 2022

    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