Import and Export Bulk Excel Data in PEGA

Pega provides a variety of rules to do Import and Export Bulk Excel, but in this case, we will use "MSOParseExcelFile" for Pega Read Excel File and "MSOGenerateExcelFile" for Pega Write Excel File.

MSOParseExcelFile (Pega Read Excel File)
Logic pseudocode:

• Upload binary template
• Set Parameter for MSOParseExcelFile
• Create a new Page List for accomodate Excel Data 
• Call MSOParserExcelFile
• Looping the page list from Excel Data
• Open the case using obj-open by pyID
• Update the case value base on excel mapping
• save - commit
• remove page

Here is the template Capture.



Here is the Activity Capture for MSOParseExcelFile

MSOGenerateExcelFile (Pega Write Excel File)
Logic pseudocode: 

• Upload binary template
• Read Data (from DB, Clipboard, etc)
• Mapping the value as binary template
• Call MSOGenerateExcelFile 

Here is the Template Capture


Here is the Activity Capture for MSOGenerateExcelFile