How to read an excel sheet and create a record in data object?

[Bhumireddy (Bhumireddy Veera Ashokkumarreddy)]

Hi @Deepika_Sree ,

Please go through the below article, You will get some idea on this.

Excel File

How to build uploading Excel file function

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

How to build uploading CSV file function

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

Streamlining Data Entry in Pega Constellation Applications with pxParseExcel

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…

Another method You can try by using Dataflow and Dataset

I hope this will help you

Thanks,
Ashok