Hi,
I have a use case where I have to read an excel containing a matrix of values. I want to insert a record in the data object for every row in the matrix. How to implement this?
Bhumireddy
September 6, 2026, 1:22pm
2
Hi @Deepika_Sree ,
Please go through the below article, You will get some idea on this.
Excel File
Hi,
In this post, I will share how to build uploading Excel file to Page List function using pxParseExcelFile activity. Please see attached for the tutorial. I also included an Excel template file and sample data I used in the tutorial.
[Upload Excel file overview.gif]
* Notes:
People used to use another out-of-the-box activity called MSOParseExcelFile for uploading Excel file in Pega 7, but it is now deprecated in Pega 8 and you are suggested to use “pxParseExcelFile” instead. However, as o…
CSV File
Hi,
In this post, I will share how to build uploading CSV file function to Page List using pxUploadCSVResults activity. Please see attached for the tutorial.
[Upload CSV file overview.gif]
This document includes the following tips:
How to handle embedded page (pyWorkPage) and top page (non-case context)
How to avoid PRRuntimeException error
How to allow Japanese characters in the Shift-JIS formatted CSV file
How to map different names between header in CSV file and actual properties
* Rela…
Or
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.
Another method You can try by using Dataflow and Dataset
I hope this will help you
Thanks,