SUMMARY
In some cases, we need to create excel and upload as attachment to mail. This tasks is so simple when done manually, but we cannot be doing the same work everyday if we need to send Excel sheet everyday. We can try to automate it. But the automation should be as accurate as manual. It sounds very good, but sending a formatted excel document is not so easy.
We can simply attach a CSV which will automatically open in Excel, but CSV is not good for below reasons :
1. CSV does not show columns in correct length.
2. CSV does not color certain fields.
3. CSV will not show bold or italics.
So, the purpose will not be solved with CSV. So here I will use Microsoft ACE to generated the formatted report.
CODE
In some cases, we need to create excel and upload as attachment to mail. This tasks is so simple when done manually, but we cannot be doing the same work everyday if we need to send Excel sheet everyday. We can try to automate it. But the automation should be as accurate as manual. It sounds very good, but sending a formatted excel document is not so easy.
We can simply attach a CSV which will automatically open in Excel, but CSV is not good for below reasons :
1. CSV does not show columns in correct length.
2. CSV does not color certain fields.
3. CSV will not show bold or italics.
So, the purpose will not be solved with CSV. So here I will use Microsoft ACE to generated the formatted report.
CODE
CONCLUSION
This article is still being written.
No comments:
Post a Comment