topic Re: build xls table in Application Development and Automation Discussions

build xls table

Former Member — Tue, 26 Dec 2006 10:40:29 GMT

hi,

i am building xls table to send as an attachment to external mail.

i am able to generate will xls file as attachment.

i have 21 fields. but only 13 headers are coming in the output. rest 8 headers are not populating in the xls file.

infact while opening the file from mail message is coming as the file is not in recognisable format.

what will be root cause. any ideas

Re: build xls table

Former Member — Tue, 26 Dec 2006 10:54:59 GMT

Hi,

in debugging i checked. at append it_attach values are not appending from text-016.

DATA: it_attach TYPE STANDARD TABLE OF solisti1 INITIAL SIZE 0

WITH HEADER LINE.

i declared it_attach like above.

FORM build_xls_data_table.

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

text-011 text-012 text-013 text-020 text-014 text-015

text-016 text-017 text-019 text-021 text-022 text-023

text-024 text-025 text-026 into it_attach

SEPARATED By con_tab.

append it_attach.

sort t_output by lot_id ascending.

Re: build xls table

Former Member — Tue, 26 Dec 2006 10:57:07 GMT

solisti1 have only lenght 255 char.

increase it .it will work.

DATA: begin of it_attach occurs 0,

field1(1000),

end of itab.

FORM build_xls_data_table.

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

text-011 text-012 text-013 text-020 text-014 text-015

text-016 text-017 text-019 text-021 text-022 text-023

text-024 text-025 text-026 into it_attach-filed1

SEPARATED By con_tab.

append it_attach.

null

Re: build xls table

Former Member — Tue, 26 Dec 2006 11:01:56 GMT

Hi kishan,

thnaks just now i seen it. how to increase the size.

is there any other standard structure like SOLISTI1 with more length.

thanks for patience.

Re: build xls table

Former Member — Tue, 26 Dec 2006 11:03:11 GMT

hi kishan,

problem solved.

thank you. closing the issue