Question

1
Replies
168
Views
Close popover
Mahendra Kumar (MahendraK9977)
BNP Paribas

BNP Paribas
IN
View Profile
MahendraK9977 Member since 2017 7 posts
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 ?.

Pega Platform Data Integration
Close popover
Moderation Team has archived post
Posted: 2 years ago
Close popover
John Pritchard-Williams (JOHNPW_GCS)
PEGA
Client Support Team Lead
PEG
GB
View Profile

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 Share via LinkedIn Copying...
Copied!