Question

2
Replies
788
Views
 Jakeer Hussain Shaik (JakeerHussainS)
Vishnu Institute Of Technology

Vishnu Institute Of Technology
IN
JakeerHussainS Member since 2018 1 post
Vishnu Institute Of Technology
Posted: February 27, 2019
Last activity: March 5, 2019
Posted: 27 Feb 2019 3:35 EST
Last activity: 5 Mar 2019 2:12 EST
Closed

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.

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 2 years ago
Posted: 5 Mar 2019 2:12 EST
Abhinav Gupta (Abhinav7)
PEGA
Principal Technical Solutions Engineer
Pegasystems Inc.
IN

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