Question

Reading data form excel sheet to pega application

i have a requirement that PEGA application(Version 7.4) has to read data from excel file and populate in a section.

Comments

Keep up to date on this post and subscribe to comments

Pega
March 5, 2019 - 2:12am

Hi,
To use Excel for uploading data in bulk, you must create the following items:

An Excel template
A binary file to save the Excel template
Download and upload activities
A user interface section that uses controls for downloading and uploading the template

OOTB activity:@baseclass.MSOParseExcelFile is useful for your requirement. It has a Java step where the whole logic is written in it.

Thanks,
Abhinav