How to import data from excel File ?
requirement :
I need to import data from excel file and need to save those data to data table .
for the section I used control MSOFileTransferButtons for upload excel
i used OOTB activity MSparseexecelFile
can anyone help me step by step how to configure this
thanks
***Edited by Moderator: Pallavi to change content type from Discussion to Question***
HCL Technologies Limited
IN
Hi,
For MSOParseExcelFile, it accepts Binary file template as input. So, First create a Binary file with all columns headings and map the column values with property accordingly.
Maantic Inc
US
Please confirm your pega version?
Pega has OOTB functionality to import and export data to data table.
Click on the datatable, go to records tab, click on action menu option - it has import and export option.
to import data - first we need excel template - you can get excel template using export option.
data table has option for rule delegation.
In last version (V8), you have option to customize the user view.