topic Re: Mail xls open error. in Application Development and Automation Discussions

Mail xls open error.

balamurugan_ramakrishnan — Thu, 30 Oct 2008 13:46:08 GMT

Hi All,

From internal table uploaded all content in xls file and attached it in mail and send.

using SO_NEW_DOCUMENT_ATT_SEND_API1 FM.

While opening the attachment file .xls it is showing following error.

"The file you trying to open .xls is in a different format than specified by the file extension."

But if open it the content inside is perfect. But always showing the error give negative impact about the data inside.

How to solve this.

Thanks,

Balamurugan.R

Re: Mail xls open error.

Former Member — Thu, 30 Oct 2008 13:54:03 GMT

Hi,

please show how do you fill the attachment and do you call the FM.

Regards, Dieter

Re: Mail xls open error.

Former Member — Thu, 30 Oct 2008 14:05:14 GMT

Hi Bala,

Check out the link:

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/email%2bfrom%2bsap

This might help you to solve your problem.

Thanks,

Chidanand

Re: Mail xls open error.

balamurugan_ramakrishnan — Fri, 31 Oct 2008 06:46:57 GMT

Hi Dieter,

From internal table using following code create a t_objbin and call FM.

LOOP AT <fs_table> ASSIGNING <fs_line>.

v_index = c_1.

*-- Final table contains selected fields.

DO.

v_len1 = STRLEN( t_objbin ).

ASSIGN COMPONENT v_index OF STRUCTURE <fs_line> TO <fs_fld>.

IF sy-subrc NE 0.

EXIT.

t_objpack-transf_bin = c_x.

t_objpack-head_start = c_1.

t_objpack-head_num = c_0.

t_objpack-body_start = c_1.

DESCRIBE TABLE t_objbin LINES t_objpack-body_num.

t_objpack-doc_type = c_xls.

t_objpack-obj_descr = c_attach.

APPEND t_objpack.

Thanks,

Balamurugan.R

Re: Mail xls open error.

balamurugan_ramakrishnan — Fri, 31 Oct 2008 11:25:26 GMT

Hi Chidanand,

When i attach the XLS internally , if my first column is Created by , in XLS it is showing 50 coulmn. why?

and XLS file format error.

Thanks,

Balamurugan.R