Question
Cognizant Technology Solutions
GB
Last activity: 4 Jul 2017 16:02 EDT
How to Attach a RFB generated excel with WO
The requirement is like below-
We have a client provided excel template for which we have added a RFB instance. It contains properties from WO.
At run time client wants this excel to be attached with the WO with all the values of the properties.
We are able to download the excel file with all required data at runtime using MSOGenerateExcelFile but not able to attach the same with WO. Only the excel template is getting attached but not the excel with all the values.
Thanks in advance for your help.
Accepted Solution
Cognizant Technology Solutions
GB
Hi Santanu,
Yes I have already checked it. In our application the main issue wasn't attaching the excel with WO. The issue was to fetch the excel content in a string property which will have all populated data. At run time only RFB template content was getting attached with WO. However We have found an OOTB activity pzMSOGenerateExcelAndSaveToWorkFileAttachment which does the trick. We saved it in a different name in our application, parameterized the hard coded properties and added a Link-Object step. Now its working fine for us.
Accepted Solution
Cognizant Technology Solutions
GB
Hi Santanu,
Yes I have already checked it. In our application the main issue wasn't attaching the excel with WO. The issue was to fetch the excel content in a string property which will have all populated data. At run time only RFB template content was getting attached with WO. However We have found an OOTB activity pzMSOGenerateExcelAndSaveToWorkFileAttachment which does the trick. We saved it in a different name in our application, parameterized the hard coded properties and added a Link-Object step. Now its working fine for us.