Question
Cittacore Technologies Pvt Ltd
IN
Last activity: 8 Jul 2025 12:56 EDT
Excel Parsing in Pega Constellation 24.2
Hi everyone,
We have a requirement wherein an user can upload an excel file (using Attachment field type). The uploaded excel needs to then be parsed into a pagelist and displayed on the next screen.
I do understand pxParseExcelFile but I am not able to figure out how can be I link my attachment field file to parseExcelFile in Constellation where we can't use section and filepath. pxRequestor.pyFileName is empty.
How to parse excel file from attachment field
Can someone please help me with getting the attachment path?
Accepted Solution
Updated: 7 Jul 2025 23:45 EDT
Publicis Sapient
IN
Hope this helps
You're not able to see the uploaded Excel file path (like pxRequestor.pyFileName) because in Constellation, files uploaded through the Attachment field don’t get stored on your local system. Instead, the file is saved inside the case as an attachment. That’s why when you try to parse it using pxParseExcelFile, it doesn’t work—because the rule expects a proper file path. To fix this, after the user uploads the file, you need to write a small activity that takes the attached file, saves it as a real file on the server, and then use that file path to parse the Excel using pxParseExcelFile.
Cisco
IN
@ShanmukaShashankV- I'm also facing same issue in constellation. Did you find any solution for this?
Cittacore Technologies Pvt Ltd
IN
@DharaniM5625 Not yet, still trying to figure it out.
Tata Consultancy Services
IN
@ShanmukaShashankV I am also facing the same issue in constellation 24.2. Please share if you get any solution.
Tata Consultancy Services
IN
I tried the approach suggested in the question below. It worked for me.
Pegasystems Inc.
US
Hello!
So sorry that you haven't been able to get a reply to your question with Constellation.
We have a new place where you can ask Constellation questions and there is a team that can assist you! Do you mind joining our User Experience Expert Circle and posting your question there?
Accepted Solution
Updated: 7 Jul 2025 23:45 EDT
Publicis Sapient
IN
Hope this helps
You're not able to see the uploaded Excel file path (like pxRequestor.pyFileName) because in Constellation, files uploaded through the Attachment field don’t get stored on your local system. Instead, the file is saved inside the case as an attachment. That’s why when you try to parse it using pxParseExcelFile, it doesn’t work—because the rule expects a proper file path. To fix this, after the user uploads the file, you need to write a small activity that takes the attached file, saves it as a real file on the server, and then use that file path to parse the Excel using pxParseExcelFile.
Cittacore Technologies Pvt Ltd
IN
@PoojaPalla Thank you so much for the input.