Question
1
Replies
168
Views
BNP Paribas
Posted: August 1, 2018
Last activity: August 6, 2018
Closed
Creating Excel with multiple number of Sheets (number of sheets to be determined in run time)
Hi,
I would like to know if it is possible to generate an excel where the sheets in the excel would be determined at run time.
Scenario:
A user can have multiple addresses (home temporary, home permanent, office, etc.) and say I have them in a page list.
I would like to display them in excel in individual sheets and the name of the sheet should be the corresponding address.
Sheet 1 - Home Temporary
Sheet 2 - Home Permanent
likewise..
Can any one share if this is feasible ?.
It is feasible - but I think you are going to have to write a fair amount of this functionality your self.
See here for an example of doing this - it uses Apache POI (a 3rd party library which ships with PRPC)
https://mesh.pega.com/docs/DOC-89449