Question
Wells Fargo
IN
Last activity: 3 Apr 2019 9:58 EDT
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****
Pegasystems Inc.
US
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://collaborate.pega.com/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://collaborate.pega.com/question/how-parse-data-excel-file-attached-work-object-pega-74
Hope it might help you.
Regards,
Mahesh M
Cognizant
SE
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.