Posted: 21 Sep 2015 14:11 EDT Last activity: 6 Dec 2015 2:26 EST
Send mail with excel attached without WO
My requirement is to run reportdefinition and get content and convert content to excel and send this excel to mail as attachment.
My approach :
got content and created HTML of that and set to property using property-set-HTML and now i need to convert this into excel then into byte code(base64) and send to sendnotificationwithallattachment.
Problem: can't use exportToExcel it will generate excel file and will ask to save it and this file can't be sent to mail. Is there any Pega method like HTMLToPdf for excel so that i can convert to into byte array and send to mail as attachment
While using Property-Set-HTML, if you use Rule-Obj-Report-Definition.pzListViewExcelData HTML stream content is set in Excel format.
This is the HTML stream used in 'export to excel' feature on Report Definition results window. I think once this is done you can use this property (set with data in excel format) to attach this as a file for email notification.
Am i missing something here ? If you already have a report, you can click on the "gear" icon on the right to schedule the report. It allows you to process the output as Excel and send notifications in email automatically.
Do you have idea Which agent will process that scheduled report and how its Processing that? even i have a requirement similar to that, but in different scenario i need to get the list of results and Send in Email Attachment.
@JunjarSinghB, did you get the activity. Can you please share how you done that requirement?