Discussion
Send mail with excel attached without WO
Hi,
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
Hi Junjar,
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.
Hope this helps you.
Murali...