Importing Excel files and saving the data in a Data table
Hi I have a requirement that on click of a button i need to browse and upload excel files into Pega.The requirement is that i have to upload the excel files read the data in it and save it in a Data Table.
Can anyone kindly help me with the step by step implementation of the same requirement so that it will be useful for me to implement the same.
Thanks in advance
***Edited by Moderator: Lochan to update platform capability tags***
try creating an Excel template and a binary file to save the Excel template and a section to upload the file and use an OOTB activity "MSOParseExcelFile" to parse Excel file and store it in a pagelist and then later you can map it to your data table.
and please refer to the following link for more details:-