Summary

Error Messages

Steps to Reproduce

1. Load an input 'xlsx' template in to the directory as a binary file (for example, excel/template.xlsx).
2. Create a section with a repeat grid and add a button in the grid.
3. Configure button actions with 'Refresh this Section' action.
4. Provide input parameters to invoke the MSOGenerateExcelFile activity.

Root Cause

Resolution

1. Create a wrapper activity (for example, TEMPExportExcel) and call the MSOGenerateExcelFile activity.
2. Copy the following JavaScript function to the UserWorkForm.

       function downloadMSExcel(fsFileName, templateRFB, downloadFile ){ 
       var form = document.createElement('form'); 
       form.id = "formExportViewToExcel"; 
       form.method = "POST"; 
       form.target = "_target"; 
       document.body.appendChild(form); 
       var frm = document.forms["formExportViewToExcel"]; 
       var strUrlSF = SafeURL_createFromURL(pega.u.d.url); 
       strUrlSF.put("pyActivity", "TEMPExportExcel"); 
       strUrlSF.put("FSFileName", fsFileName); 
       strUrlSF.put("TemplateRFB", templateRFB); 
       strUrlSF.put("DownloadFile", downloadFile); 
       frm.action = strUrlSF.toURL(); 
       frm.submit(); 
       document.body.removeChild(form); 
       } 

      </script>

     3. Call the 'downloadMSExcel' custom function from the button click with 'Run Script' action.