Read Excel sheet data and Display Data

Blueprint and App Design
, , , , , , , , , , , ,
1

Hello,

I’m currently working on a feature where users can upload Excel sheets containing data, and I need assistance with the following:

  1. Reading the data from the uploaded Excel sheet.
  2. Displaying this data in a visually appealing table within a Pega application.

Could you please provide guidance on how to achieve this? Your expertise in this matter would be greatly appreciated.

Thank you.

2

Hi @Eranda10274: Please see this.

You should be able to use pxParseExcelFile.

Thanks.

3

@ArulDevan Thank you ArulDevan.

4

@Eranda10274

We have a couple of steps involved here:

  1. Create a Data table to get the Page with property

  2. Create a binary file for the Excel file to upload

  3. Create an activity to parse the excel use(pxParseExcelFile) OOTB method.

  4. Create a section to display the data

please follow this below link it’s explained in detail:

https://mypegapoc.com/2022/04/upload-an-excel-file-parse-it-and-display-the-content/

5

Thank you @Ankush Agrawal