topic Re: Formatting excel using 'SO_NEW_DOCUMENT_ATT_SEND_API1' in Application Development and Automation Discussions

Formatting excel using 'SO_NEW_DOCUMENT_ATT_SEND_API1'

Former Member — Thu, 06 Aug 2009 04:05:17 GMT

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.

Re: Formatting excel using 'SO_NEW_DOCUMENT_ATT_SEND_API1'

gaursri — Thu, 06 Aug 2009 04:37:04 GMT

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.

Re: Formatting excel using 'SO_NEW_DOCUMENT_ATT_SEND_API1'

Former Member — Thu, 06 Aug 2009 12:49:07 GMT

check the follwoing link

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

Re: Formatting excel using 'SO_NEW_DOCUMENT_ATT_SEND_API1'

Former Member — Thu, 06 Aug 2009 20:03:13 GMT

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.

Re: Formatting excel using 'SO_NEW_DOCUMENT_ATT_SEND_API1'

Former Member — Fri, 07 Aug 2009 03:53:24 GMT

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

Re: Formatting excel using 'SO_NEW_DOCUMENT_ATT_SEND_API1'

Former Member — Fri, 07 Aug 2009 04:44:06 GMT

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