Question

1
Replies
162
Views
MahendraK9977 Member since 2017 7 posts
BNP Paribas
Posted: 2 years ago
Last activity: 2 years 2 months ago
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 ?.

Pega Platform Data Integration
Close popover
Moderation Team has archived post
Posted: 2 years ago

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
Share this page LinkedIn
Copied!