# Excel Parsing in Pega Constellation 24.2

**URL:** <https://forums.pega.com/t/excel-parsing-in-pega-constellation-24-2/9538>\
**Category:** General\
**Tags:** platform, constellation, pega-platform\
**Created:** [June 3, 2025, 3:52pm UTC](https://forums.pega.com/t/excel-parsing-in-pega-constellation-24-2/9538 "2025-06-03T15:52:33Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![ShanmukaShashankV1](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/shanmukashashankv1/32/23455_2.png) [@ShanmukaShashankV1](https://forums.pega.com/u/ShanmukaShashankV1)\
**Post date:** [June 3, 2025, 3:52pm UTC](https://forums.pega.com/t/excel-parsing-in-pega-constellation-24-2/9538/1 "2025-06-03T15:52:33Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![DharaniM5625](https://avatars.discourse-cdn.com/v4/letter/d/5f8ce5/32.png) [@DharaniM5625](https://forums.pega.com/u/DharaniM5625)\
**Post date:** [July 3, 2025, 9:04am UTC](https://forums.pega.com/t/excel-parsing-in-pega-constellation-24-2/9538/2 "2025-07-03T09:04:58Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ShanmukaShashankV1](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/shanmukashashankv1/32/23455_2.png) [@ShanmukaShashankV1](https://forums.pega.com/u/ShanmukaShashankV1)\
**Post date:** [July 3, 2025, 2:43pm UTC](https://forums.pega.com/t/excel-parsing-in-pega-constellation-24-2/9538/3 "2025-07-03T14:43:39Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![MarissaRogers](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/marissarogers/32/23444_2.png) [@MarissaRogers](https://forums.pega.com/u/MarissaRogers)\
**Post date:** [July 3, 2025, 2:45pm UTC](https://forums.pega.com/t/excel-parsing-in-pega-constellation-24-2/9538/4 "2025-07-03T14:45:35Z")

</div>

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](https://community.pega.com/expert-circle/user-experience?) and posting your question there?

---

<div class="post-metadata">

**Author:** ![PoojaPalla](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/poojapalla/32/12434_2.png) [@PoojaPalla](https://forums.pega.com/u/PoojaPalla)\
**Post date:** [July 7, 2025, 3:16pm UTC](https://forums.pega.com/t/excel-parsing-in-pega-constellation-24-2/9538/5 "2025-07-07T15:16:31Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![RAJASEKAR\_KATHIRVEL](https://avatars.discourse-cdn.com/v4/letter/r/c89c15/32.png) [@RAJASEKAR\_KATHIRVEL](https://forums.pega.com/u/RAJASEKAR_KATHIRVEL)\
**Post date:** [July 4, 2025, 10:08am UTC](https://forums.pega.com/t/excel-parsing-in-pega-constellation-24-2/9538/6 "2025-07-04T10:08:18Z")

</div>

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

> **[Parsing .xlsx with pxParseExcel "Parse failed for the uploaded file.Cannot...](https://support.pega.com/question/parsing-xlsx-pxparseexcel-parse-failed-uploaded-filecannot-find-zip-signature-within-first)**
>
> 1) Used Constellation Application 2) Configured Attachment Control to upload a xlsx file 3) On the submission of the view in the Case Type rule triggered an Utility to read the attachment key to open the attachment and triggered pxCreateFile Activity...

---

<div class="post-metadata">

**Author:** ![ShanmukaShashankV1](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/shanmukashashankv1/32/23455_2.png) [@ShanmukaShashankV1](https://forums.pega.com/u/ShanmukaShashankV1)\
**Post date:** [July 8, 2025, 4:56pm UTC](https://forums.pega.com/t/excel-parsing-in-pega-constellation-24-2/9538/7 "2025-07-08T16:56:43Z")

</div>

@PoojaPalla Thank you so much for the input.

---

<div class="post-metadata">

**Author:** ![RAJASEKAR\_KATHIRVEL](https://avatars.discourse-cdn.com/v4/letter/r/c89c15/32.png) [@RAJASEKAR\_KATHIRVEL](https://forums.pega.com/u/RAJASEKAR_KATHIRVEL)\
**Post date:** [July 4, 2025, 8:21am UTC](https://forums.pega.com/t/excel-parsing-in-pega-constellation-24-2/9538/8 "2025-07-04T08:21:26Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Swargam\_Avinash](https://avatars.discourse-cdn.com/v4/letter/s/f4b2a3/32.png) [@Swargam\_Avinash](https://forums.pega.com/u/Swargam_Avinash)\
**Post date:** [April 7, 2026, 6:38am UTC](https://forums.pega.com/t/excel-parsing-in-pega-constellation-24-2/9538/9 "2026-04-07T06:38:14Z")

</div>

### **Step-by-step explanation**

 ![image](https://pega1.discourse-cdn.com/pega/original/3X/f/5/f5dcb01d8ab0a898faaae5476a596d4be3d543e8.png)

#### **1. Property-Set**

- **Purpose:** Initialize or set required properties before processing.

- Typically used to:

* * *

#### **2. Obj-Open-By-Handle (Step Page: AttachPg)**

- **Purpose:** Open an attachment using its handle.

- **What it does:**

- This is essential because attachments are stored as binary objects.

* * *

#### **3. Property-Set (on AttachPg)**

- **Purpose:** Prepare attachment metadata for parsing.

- Likely sets:

- Ensures the next step (file creation/parsing) works correctly.

* * *

#### **4. Call pxCreateFile (Step Page: CreateFile)**

- **Purpose:** Convert attachment into a file object.

- **What it does:**

- This step is required before parsing Excel content.

* * *

#### **5. Property-Set**

- **Purpose:** Configure parameters for Excel parsing.

- Likely sets:

* * *

#### **6. Call pxParseExcelFile (Step Page: TempVehicleListPage)**

- **Purpose:** Parse the Excel file into clipboard data.

- **What it does:**

---

<div class="post-metadata">

**Author:** ![ShanmukaShashankV1](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/shanmukashashankv1/32/23455_2.png) [@ShanmukaShashankV1](https://forums.pega.com/u/ShanmukaShashankV1)\
**Post date:** [April 7, 2026, 8:15am UTC](https://forums.pega.com/t/excel-parsing-in-pega-constellation-24-2/9538/10 "2026-04-07T08:15:16Z")

</div>

Thanks for the input—I’ll implement it right away.

---

<div class="post-metadata">

**Author:** ![RameshSangili](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/rameshsangili/32/23377_2.png) [@RameshSangili](https://forums.pega.com/u/RameshSangili)\
**Post date:** [April 7, 2026, 10:45am UTC](https://forums.pega.com/t/excel-parsing-in-pega-constellation-24-2/9538/11 "2026-04-07T10:45:05Z")

</div>

@ShanmukaShashankV Please check this article to extract the excel data in Constellation

> [@Streamlining Data Entry in Pega Constellation Applications with pxParseExcel](https://forums.pega.com/t/streamlining-data-entry-in-pega-constellation-applications-with-pxparseexcel/9770):
>
> In Pega Constellation and Traditional UI applications, the pxParseExcel feature provides an efficient solution, enabling users to import Excel spreadsheets and automatically convert the data into Embedded Data. This article demonstrates how to leverage pxParseExcel, complete with step-by-step instructions and screenshots, to simplify the process and enhance user experience. Step-by-Step Guide Step 1: Prepare and Import the Excel Template Create an Excel file containing all the required Custom…
