@DiegoP29

Hi,

Please go-through the below link. It's similar kind of requirement as yours .This might be helpful. 

To parse excel content and uploading data in bulk and mapping it to clipboard structure, you need to create following rules:

1)An Excel template:-

2)A binary file to save the Excel template. Refer it to process excel content and upload:-https://docs-previous.pega.com/configuring-application-bulk-upload-data-using-excel-spreadsheet 

3) Download and upload activities(Processing of excel data and creating work object). An OOTB "MSOParseExcelFile" activity can be used to parse your input and map it to clipboard page.

4)A user interfaces section that uses controls for downloading and uploading the template.                       

Following above steps would load excel data in a page list format at the clipboard, The above steps will load excel data to page list property (from above example: excelDetails() ) with multiple number of rows (number of rows given your input excel sheet).

5)Iterate each row and create work object as per your requirement.

6)How to automatically create a new work object- https://community.pega.com/how-automatically-create-new-work-object-and-transfer-it-subflow