Question
Virtusa PVT Ltd
LK
Last activity: 12 Feb 2024 10:01 EST
Read Excel sheet data and Display Data
Hello,
I'm currently working on a feature where users can upload Excel sheets containing data, and I need assistance with the following:
- Reading the data from the uploaded Excel sheet.
- 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.
Accepted Solution
Updated: 19 Feb 2024 9:19 EST
Truviq Systems
NL
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/
Updated: 12 Feb 2024 10:01 EST
NCS Pte. Ltd
SG
Virtusa PVT Ltd
LK
@ArulDevan Thank you ArulDevan.
Accepted Solution
Updated: 19 Feb 2024 9:19 EST
Truviq Systems
NL
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/
Virtusa PVT Ltd
LK
Thank you @Ankush Agrawal