Export Simple list output to Excel sheet.

[Former Member]

Hi gurus,

I have a list output as follows.

A main header

Sub header 1

table entries.

sub header 2.

table entries ,......etc.

now i want to export the same format to an excel sheet which need to sent as a mail attachment.

Is there any FM for this ? i dont want the format to be disturbed.

can headers and other entries defferentiated with colors ?

kindly help on this.

Edited by: deepan adhi on Oct 4, 2009 9:52 AM

[former_member205763]

All the list output data must be in some output internal table so use this fm SAP_CONVERT_TO_XLS_FORMAT to get the data into excel.

[Former Member]

Hi Karthik,

thanks for the reply.

yes there is a final internal table.

But on doing so , the format i have mentioned in the question would be changed.

i want the output format to be maintained in the excel sheet too.

thanks.

[Former Member]

write the list to memory,

and the read this memory into an internal table. this will be exactly the same way as its printed on your screen. download it.

or

create an internal table of type string, add pass data from your final internal table in the exact way you are putting it in the output.

and download this string internal table.