Sending a excel sheet as attachment in mail

[Former Member]

Hi,

I have requirement where I need to send excel sheet as attachment in mail. I could do it by using FM SO_NEW_DOCUMENT_ATT_SEND_API1. But, I am not able to format the excel sheet before sending.

I need to make heading bold, fix column width and wrap text in some cells, and send the mail.

Pls help me with your suggestions.

Thanks,

Siva.

[Former Member]

Check this thread. Some links in the thread will resolve the issue.

https://forums.sdn.sap.com/click.jspa?searchID=17027116&messageID=6005843

-Aman

[Former Member]

This message was moderated.

[former_member480923]

this link will show you how to do formatting in Excel using the OLE method, then use that EXCEL to send the MAIL using your program \

[OLE-format excel |http://www.sap-img.com/abap/download-to-excel-with-format-border-color-cell-etc.htm]

Hope That Helps

Anirban M.

[Former Member]

Hi,

My requirement is to make header in bold, fix column width and to wrap text.

I have the data in an internal table and data is seperated by tabs ane new lines.

Can I use OLE to format the data in internal table???

Is there any other way to do this??

Thanks

Siva.

[former_member480923]

The properties that you have mentioned are EXCEL properties and methods, not sap ones - so you need to look at excel help to determine how a particular function is structured. then

build the block in sap, as shown in the example code.

you can also Check out the FM: XXL_FULL_API for advanced API features of Excel.

Hope That Helps

Anirban M.