Excel export with mutiple tabs using pxGenerateExcelFile
I have a requirement where I need to generate an excel file using Multiple 2 lists.
And each of the list should have its own tab.
The fields and lists are static.
The application is running on Pega 8.3.0.
I am using the activity "pxGenerateExcelFile".
This activity is able to open the excel file in step 2.
But, fails in the Java Step (Step 4).
I am trying to refer to refer each field as {list.pxResults().propertyName} in the template.
But, this return the error reason as -
unexpected character ')' at position 31, expected subscript (wildcards not allowed)
However, the same binary file was correctly on Pega 7.4 and was able to generate excel file with multiple tabs.
On this pega version we were using the activity "MSOGenerateExcelFile".
But, this activity has been depricated by Pega.
Pega recommends the use of activity "pxGenerateExcelFile" for generating excel file.
Any solution for this issue with the use of "pxGenerateExcelFile" ?
***Edited by Moderator Marissa to update platform capability tags****
ai4process
PL
Hello
The main difference between MSOGenerateExcelFile and pxGenerateExcelFile is the way how you are referring to properties within the template.
In MSOGenerateExcelFile you can use references to top level pages and this works fine.
In pxGenerateExcelFile you need to reference properties from your context page.
So when switching directly from MSOGenerateExcelFile to pxGenerateExcelFile you need to take care of references in your template.
Thanks
Pegasystems Inc.
IN
MSOGenerateExcelFile is an internal rule and was not supported for external uses. Its even marked deprecated now. pxGenerateExcelFile is an available API, so that even customers can generate excel files based on templates and clipboard data. Having said that, it has its limitations. pxGenerateExcelFile doesn’t support multiple tabs. If this is needed, please get in touch with Pega support to raise a feedback request for future consideration.
Regards,
Suman