Formatting excel using 'SO_NEW_DOCUMENT_ATT_SEND_API1'

[Former Member]

Hi,

I am having an issue in formatting excel content while sending as an attachment through a mail. I am using the FM 'SO_NEW_DOCUMENT_ATT_SEND_API1'. I am getting an excel output as an attachment with the mail, but I would like to do formatting too in excel like add straight lines or add color to headings. Is this possible ?? I tried searching for this solution but I ain't getting anywhere. Please help if you have got any.

Regards

Raj.

[Former Member]

Hi,

Check this web blog for colouring excel attachements. It is possible to format the excel the way we wish by using OLE2 objects.

[https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13091] [original link is broken] [original link is broken] [original link is broken];

Hope it helps.

Regards,

Vik

[gaursri]

Hi Abhishek,

I am sending you the code example for lines addition you can go through hope you find it useful in the query which you are facing now.

Link:[Query|;

Hope your query resolved soon.

Have a best day ahead.

[Former Member]

check the follwoing link

http://www.sapdev.co.uk/reporting/email/email_mbody.htm

[Former Member]

Hey Guys,

Thanks for the help.. but it is not useful for me. I already said I am able to get the output in excel format with data in correct column headings. I just want an example or a link where the formatting of adding vertical lines between data and coloring of headings are done before attaching to the mail.

Regards

Raj.

[Former Member]

Hi,

Check this web blog for colouring excel attachements. It is possible to format the excel the way we wish by using OLE2 objects.

[https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13091] [original link is broken] [original link is broken] [original link is broken];

Hope it helps.

Regards,

Vik

[Former Member]

HI

I think so it is not possible to change the format while sending as an attachment through FM so_new_documnet_send_att_apil.

for formatting the excel sheet we can use OLE methods

Thanks