Question

3
Replies
285
Views
Close popover
Vivek Kumar (VivekK57)
Billennium

Billennium
IN
VivekK57 Member since 2018 1 post
Billennium
Posted: January 30, 2020
Last activity: February 10, 2020
Closed

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****

Low-Code App Development Data Integration Java and Activities System Administration Upgrades
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.