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

 Pritam Chakraborty (PritamChakraborty)
Eviden
Pega LSA
Eviden
NL
PritamChakraborty Member since 2012 18 posts
Eviden
Posted: Aug 16, 2016
Last activity: Sep 19, 2016
Posted: 16 Aug 2016 9:15 EDT
Last activity: 19 Sep 2016 8:23 EDT
Closed
Solved

How to Parse an Excel file which is separated by cells ?

Hi All ,We have a excel file which needs to be parsed. The excel file is not separted by comma and each cell is reperesnted as a sperate value.

Ecxel format

Expected output in clipboard 
Employee(1).FirstName="XXX"

Employee(1).LastName="YYY"

Employee(1).position="ZZZ"     Is it possible to achieve with OOTB pega ?If yes please let me know how 

***Updated by Moderator: Lochan. Removed user added Ask the Expert and FAQ tags. Apologies for confusion, shouldn't have been an end-user option; updated Categories***

 

To see attachments, please log in.
Case Management
Reporting

Posted: 8 years ago
Posted: 18 Aug 2016 3:19 EDT
Habeeb Baig (BaigHabeeb)
Virtusa IT Consulting
Lead Decisioning Architect
Virtusa IT Consulting
AE

you can implement an activity like OOTB 'MSOParseExcelFile' activity or you can make use of poi libraries in a java step of the activity.

To see attachments, please log in.
Posted: 8 years ago
Posted: 18 Aug 2016 3:19 EDT
Ashok Kumaresan (uashok93)
Areteans Tech
Associate Architect
Areteans Tech
AU

Hi ,

Call MSOParseExcelFile activity and pass the Excel file as template to this.

provide the StepPage for this calling step.

After running the activity ,Results are stored as pagelist in the Clipboard with the StepPage name

Let us know if this Works.

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