Hi Varun,

Thanks for posting on PSC.

Implementation approach,

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

• An Excel template:-
• 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 
• 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.
• 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).
• Iterate each row and create work object as per your requirement.
• How to automatically create a new work object- https://community.pega.com/how-automatically-create-new-work-object-and-transfer-it-subflow

Hope above information helps you in implementation, kindly notify if it does, by marking this post as answered or helpful for tracking purpose.

Regards,

Asif