Posted: 21 Nov 2019 0:03 EST Last activity: 25 Nov 2019 12:55 EST
How to send an excel sheet as an attachment to mail genetated through MSOGenerateExcelFile
I exported a Report definition in excel file through MSOGenerateExcelFile.I want to send the same file as an email attachment through activity.Tried SendEmailWithAttachments.Want to know how to get stream data and .pyData property
***Edited by Moderator: Lochan to update platform capability tags***
If you are generating the excel file from MSOGenerateExcelFile activity, it will just generate the file and can download the file to the local system. It will not save the file to any specific location or space.
The activity does not return any content that can be attached to the attachment page.
The pyData is the path from where the data can be accessed.
The excel generated from the MSOGenerateExcelFile activity will be stored in the ServiceExport directory. From the directory, the file can be added to the desired location.
Hello Asma, By taking reference from "Scheduled Report" functionality, I have developed a working solution which I have kept at below google drive location. You can check and customize as per your requirement.