How to send report grid data in .xls format in email using email template
Hello team, We have created a email template in which we want to attach report grid data in .xls, we have used report grid to display data using OQL statement. How can we achieve the above ? Thanks In Advance
You can create an Excel document in a microflow with the Java action GenerateExcelDoc from the XLSReport module (https://docs.mendix.com/howto/integration/using-the-excel-exporter).
When you have the Excel document you can add it to the e-mail with the Java action CopyAttachmentContent from the EmailTemplate module.