Question
Standard Chartered
IN
Last activity: 9 Jan 2023 9:10 EST
Generate Dynamic .xlsx Excel file NOT based on binary template
I have a requirement in v8.6 to be able to export values to an excel file without invoking "MSOGenerateExcelFile" OOTB as they require a binary template.
At code development I will not be having the column header name and the corresponding column data. Those values will be populated by user selection from UI.
CSV's can be dynamically generated using "pxConvertResultsToCSV" OOTB. I need a similar approach for generating .xlsx file. Or any other solution implemented.
Updated: 4 Jan 2023 5:39 EST
Pegasystems Inc.
GB
@DwaipayanB_SCB MSOGenerateExcelFile is deprecated - using a template and the pxGenerateExcelFile activty is the recommended approach.
Activities for integrating cases with Excel documents
The template allows the ability to pick an excel template to enable the right styling on the exported sheet
If you wish to use a custom solution a good starting place is the search for code :
https://www.appsloveworld.com/r/100/281/how-to-export-the-results-into-different-tabs-of-excel-in-r
Other users can comment about what they implemented in their use-cases.
A user recently posted in question Export .csv to .xlsx with formats - perhaps that will give you some ideas.
Standard Chartered
IN
@MarijeSchillern Your response is much appreciated Marije, but the solutions shared are mostly template based excel creations. The multitab excel creation is not very descriptive and seems to use rjava which I think needs to be installed onto the Pega hosting platform. Is there a better solution available using stratighforward Java code for an activity step?
Pegasystems Inc.
GB
@DwaipayanB_SCB do the suggestions in Create and export data in excel format with multiple excel tabs created dynamically meet your requirements?
JPMC
IN
@DwaipayanB_SCB If you do not want to use templates for generating an excel file then you can make use of Apache POI library which pega includes by default.
You can refer to the below link for the java code:
https://howtodoinjava.com/java/library/readingwriting-excel-files-in-java-poi-tutorial/