Excel Parsing in Pega Constellation 24.2

General
, ,
1

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?

2

@ShanmukaShashankV- I’m also facing same issue in constellation. Did you find any solution for this?

3

@DharaniM5625 Not yet, still trying to figure it out.

4

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?

5

Hi @ShanmukaShashankV

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.

6

I tried the approach suggested in the question below. It worked for me.

7

@PoojaPalla Thank you so much for the input.

8

@ShanmukaShashankV I am also facing the same issue in constellation 24.2. Please share if you get any solution.