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

 Sripada Venkata Aditya (SVAQuest)
Tata Consultancy Services Ltd
Technical Architect
Tata Consultancy Services Ltd
AU
SVAQuest Member since 2012 96 posts
Tata Consultancy Services Ltd
Posted: Dec 28, 2017
Last activity: Dec 31, 2017
Posted: 28 Dec 2017 1:37 EST
Last activity: 31 Dec 2017 8:27 EST
Closed

Dynamically extracting the data from Excel Form to Pega

Hi All,

How to extract the data from excel attributes which are not in the column format?

For example, Captured data via excel should be displayed on the Pega UI form.But data in excel is not in the columns sequence.

It was not similar approach of loading the data via data table. Is there any approach that could be achieved using Pega OOTB functionalities for the highlighted scenarios.

Any suggestions?

To see attachments, please log in.
Data Integration

  • Shankar Anand Arber Lulashi
Posted: 7 years ago
Updated: 7 years ago
Posted: 31 Dec 2017 8:28 EST
Updated: 31 Dec 2017 8:27 EST
Lakshmi Venkatesh Kakumani (kakul)
PEGA
Associate Technical Solutions Engineer
Pegasystems Inc.
IN

If we can templatize the Excel content you have then we can parse it using MSOParseExcel. 

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