Skip to Content
0
Former Member
Jan 12, 2007 at 06:32 AM

cell separation in excel attachment

28 Views

Hi,

i am writing email application which sends mail to the distribution list as xls attachment.

i have got more than 255 row length so made my line chunks of 255 and then passing to so_api1 fm.

i am able to get the output with row length more than 255. but merging two cells here. i mean in my code text-010 and text-011 are coming in single cell.

How to overcome this?

FORM build_xls_data_table .

class cl_abap_char_utilities definition load.

constants:

con_tab type c value cl_abap_char_utilities=>HORIZONTAL_TAB,

con_cret type c value cl_abap_char_utilities=>CR_LF.

CLEAR it_attach.

CONCATENATE text-006 text-018 text-007 text-008 text-009 text-010

into it_attach

SEPARATED BY con_tab.

CONCATENATE con_cret it_attach INTO it_attach.

APPEND it_attach.

CONCATENATE text-011 text-012 text-013 text-014 text-015 text-016

into it_attach

SEPARATED By con_tab.

APPEND it_attach.

the expected output is <b>text-006 text-018 text-007 text-008 text-009 text-010 text-011 text-012 text-013 text-014 text-015 text-016</b>

but my output is coming like this

text-006 text-018 text-007 text-008 text-009 text-010text-011 text-012 text-013 text-014 text-015 text-016