Question

2
Replies
288
Views
NandiniVanjavakam Member since 2013 11 posts
EVOKETechnologies
Posted: 1 year ago
Last activity: 1 year 5 months ago
Closed

How to Parse Excel without using Binary template

We have a requirement to parse an uploaded excel file and extract the data. The file cannot be associated with any template.Therefore cannot use pxParseExcel activity., Cannot use file listener as the users will have to attach the file to WO. Please suggest any approaches to acheive this requirement.

***Edited by Moderator Marissa to update platform capability tags****

Low-Code App Development Data Integration Java and Activities Data Integration
Close popover
Moderation Team has archived post
Posted: 1 year ago

Hi Nandini,


You can go through my suggestion provided in the below discussion to write your custom code to read the excel file content as you are not sure about its format used by the end user,


https://community1.pega.com/community/product-support/question/how-read-excel-sheet


If you are aware of the format used by the end user then probably you can use the MSOParseExcelFile to read the content of the work object attachment as explained below,


https://community1.pega.com/community/pega-support/question/how-parse-data-excel-file-attached-work-object-pega-74


Hope it might help you.


Regards,


Mahesh M

Posted: 1 year ago

Hi ,


You can refer/configure pxUploadCSVResults flow action to upload the file and parse the file. Which will copy the data to specified pagelist in post action parameters.


 


Thanks,


Deva.
Share this page LinkedIn
Copied!