Conversation
CGI
IN
Last activity: 19 Aug 2025 14:06 EDT
Help with Excel Parsing in Constellation Using pxParseExcelFile
I'm trying to parse an Excel file in Constellation using the pxParseExcelFile activity in Pega. This activity requires a filepath parameter, but I noticed that it's not available in pxRequestor. I'm currently using the Community Edition of Pega.
I've gone through several support articles and community discussions where repositories are mentioned as part of the solution. However, I couldn't find any clear screenshots or documentation detailing the exact parameters that need to be set.
Could someone guide me on how to properly configure this in Constellation? Any examples or screenshots would be greatly appreciated.
Pegasystems Inc.
PL
@ShravanU Hi, have you seen this article https://community.pega.com/conversations/user-experience/streamlining-d…;
I hope this will help with your query.
Pegasystems Inc.
NL
@Kamil Janeczekgreat resource with another good example how to parse an excel attachment! The url in your post contained a typo, this is the correct URL: https://community.pega.com/conversations/user-experience/streamlining-d…
Pegasystems Inc.
NL
Assuming you want to use a case attachment, you have to create a mechanism to find the location of the case attachment and set the filepath parameter and push that into the OOTB activity pxParseExcelFile. Best is to make a generic Activity that can be reused for any attachment you want to use to parse excel into a pagelist. If you are interested i can share an example of a reusable flow where you can add your attachment reference and your excel template to parse the excel sheets into pagelists. See attached an example of an activity that prepares the filepath parameter and calls the pxParseExcelFile activity. In this example I am taking the repository filename (step 3) and combining it with the path of the default store (where my attachments are stored).
