Recently I just complet a module for generating an format excel and send it to user as attachment. The solution I choose is:
- Generating an excel file in local server,and write data to the file.
- Read the file from local and transfer it to binary
- send the xls file to user with pub.client:smtp.
As design, there is no need to generate a real file in local server but only generate it in binary. However, I don’t know how to do like this. if anyone have the idea, I appraciated for your point out.
Now I will show you the parameter setting when sending the Excel file with the methods:pub.client:smtp
The following is the contenttype list for your reference: