Question
1
Replies
1442
Views
Posted: December 14, 2017
Last activity: December 14, 2017
Closed
how to create a form by importing Excel sheet
Hi Team,
here i have requirement, i have Excel Sheet in that Excel sheet with fields. we don't create any properties or we don't create any fields in Data Type.
1.by importing the Excel Sheet only the fields will update in Data Type automatically..
2. we will convert it into Form(editable).
is it possible? could anyone please help on this??
Hi Dileep,
Thanks for posting on PSC.
You can leverage features of OOTB activity "MSOParseExcelFile" for the same.
Steps:-
3) Use the MSOParseExcelFile activity for the upload activity to parse the uploaded Excel file by using the template Excel file. After the uploaded file has been parsed, the list of parsed items is available on the embedded page list on the step page and can be used in your application.
4) In the Step Page fields, enter the context of the page.
5) In the FSFileName field, enter the file name to use for the downloaded file.
6) In the TemplateRFB field, enter the name of the template that you created and uploaded in the Binary File rule in the following format: "excel!<file>!xlsx".
Refer it:-https://pdn.pega.com/node/157426
Hope it helps you in your implementation, please notify if it does and mark as answered.
Regards,
Asif