Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Mahendra Kumar (MahendraK9977)
BNP Paribas

BNP Paribas
IN
MahendraK9977 Member since 2017 7 posts
BNP Paribas
Posted: Aug 1, 2018
Last activity: Aug 6, 2018
Posted: 1 Aug 2018 2:07 EDT
Last activity: 6 Aug 2018 11:46 EDT
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 ?.

To see attachments, please log in.
Pega Platform
Data Integration

Posted: 6 years ago
Posted: 6 Aug 2018 11:32 EDT
John Pritchard-Williams (JOHNPW_GCS) Client Support Team Lead
Pegasystems Inc.
GB

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

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice