topic Re: Formatting Excel Attachment output in SO_DOCUMENT_SEND_API1 in Application Development and Automation Discussions

Formatting Excel Attachment output in SO_DOCUMENT_SEND_API1

Former Member — Mon, 21 Apr 2008 12:11:07 GMT

Hi ABAPers,

I'm hoping someone can get me started with a requirement. I"m using SO_DOCUMENT_SEND_API1 to email a file as an excel attachment. I'm required for a four digit code to show as (0003). Instead, when I open the excel attachment, it displays as 3. Would anyone know how to set the document to show all fields as text? Any help would be appreciative.

Thanks,

Meezy

Re: Formatting Excel Attachment output in SO_DOCUMENT_SEND_API1

Former Member — Mon, 21 Apr 2008 15:22:20 GMT

In addition, I need the fields to display this way as default when the document is opened. The requirement is to not have the business perform this action.

Thanks,

Meezy

Re: Formatting Excel Attachment output in SO_DOCUMENT_SEND_API1

venkat_o — Mon, 21 Apr 2008 15:37:49 GMT

Hi Meezy, When u r building Excel attachement, take one variable of type N with length 4 and pass to excell file. Then only it is possible. Regards, Venkat.O

Re: Formatting Excel Attachment output in SO_DOCUMENT_SEND_API1

Former Member — Mon, 21 Apr 2008 16:36:35 GMT

Hi Venkat,

The program is sending the 4 digit code perfectly through excel in debug mode. However, when it's when I open the file that it get's cut off. 3000 shows up fine. Only codes with leading 0's are cut off. 3000 shows as 3000 but 0003 shows as 3.

Thanks,

Meezy

Re: Formatting Excel Attachment output in SO_DOCUMENT_SEND_API1

Former Member — Wed, 30 Apr 2008 14:23:13 GMT

I've figured it out.

Re: Formatting Excel Attachment output in SO_DOCUMENT_SEND_API1

Former Member — Fri, 06 Jun 2008 13:19:13 GMT

Meezy,

I am also loking for same solution, can you please let me know what needs to be done.

Thanks!

Thiru

Re: Formatting Excel Attachment output in SO_DOCUMENT_SEND_API1

Former Member — Sat, 15 Nov 2008 20:25:39 GMT

Hi Meezy,

Even I am trying to format my excel attachment created through FM 'SO_DOCUMENT_SEND_API1'. Can you please share your solution? Any additional tips on formatting (like framing, coloring or making the fields bold) would be helpful.

Thanks,

AMol

Re: Formatting Excel Attachment output in SO_DOCUMENT_SEND_API1

Former Member — Mon, 08 Feb 2010 11:28:05 GMT

Hi Meezy,

Can you please post the solution which you worked out.

Hope to hear from you soon!!!

Thanks