Activity pxGenerateExcelFile vs MSOGenerateExcelFile
Activity pxGenerateExcelFile vs MSOGenerateExcelFile
The RAMP application is hoisted on Pega cloud on Pega Platform 24.2.2 and built on Theme-Cosmos 05.01.
Previously for some other requirement (a single table in an excel file and send excel as an email attachment), we have used the OOTB activity pxGenerateExcel with an excel template and this is working fine.
We now have a requirement to put the complex case data in an excel and attach the same to the case. The case data contains:
- Single Value properties (Text, Boolean, Currency, Integer, Double values)
- Page Group properties
- Pagelist properties
- Paglist inside pagelist properties
- Also, ie might have to include other properties present inside Data Pages
- The Data will have to be spread across multiple sheets inside the excel file.
Queries:
Activity pxGenerateExcelFile vs MSOGenerateExcelFile
The RAMP application is hoisted on Pega cloud on Pega Platform 24.2.2 and built on Theme-Cosmos 05.01.
Previously for some other requirement (a single table in an excel file and send excel as an email attachment), we have used the OOTB activity pxGenerateExcel with an excel template and this is working fine.
We now have a requirement to put the complex case data in an excel and attach the same to the case. The case data contains:
- Single Value properties (Text, Boolean, Currency, Integer, Double values)
- Page Group properties
- Pagelist properties
- Paglist inside pagelist properties
- Also, ie might have to include other properties present inside Data Pages
- The Data will have to be spread across multiple sheets inside the excel file.
Queries:
- Activity pxGenerateExcelFile is available but seem to cater only to single table. It does not seem to cater to multiple sheets, complex and multiple tables. Is there a plan to introduce these features in future versions of the activity or is there any alternative activity?
- Activity MSOGenerateExcelFile seems to be deprecated but is available for use in 24.2.2. Also, multiple sheets and complex and multiple tables can be achieved.
- Is it planned to be withdrawn in any future version.
- Will it be available in 25.x?
- Do we see performance issues in the system in case we decide to use it till the time Pega provides an alternative.