Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Download to excel with multiple lines in header

abapdeveloper20
Contributor
0 Kudos

Hi experts,

Is there any Funtion module available to download an internal table contents into Local directory of PC with multiple lines in header.

i.e. let us say i hv internal table of 5 entries with 3 columns...

i need to download this 5 entries into an excel file with some texts above the table contents...

For eg : in the below format...

Sample line 1

sample line 2

sample line 3

colheader1 colheader2 colheader3

item1

item2

item3

item4

item5

Please help.

Edited by: Lakshmiraj on Jul 15, 2010 3:26 AM

1 ACCEPTED SOLUTION

anup_deshmukh4
Active Contributor
0 Kudos

hello Lakshmiraj,

Me too had the same requirement but I din't found any FM for the same so What i did was I arranged my data into Internal Table as i wanted and then downloaded the file,

Please respond if you find a FM .

Hope it helps,

Anup

4 REPLIES 4

anup_deshmukh4
Active Contributor
0 Kudos

hello Lakshmiraj,

Me too had the same requirement but I din't found any FM for the same so What i did was I arranged my data into Internal Table as i wanted and then downloaded the file,

Please respond if you find a FM .

Hope it helps,

Anup

0 Kudos

Thanks but how about the coloumn headers in the file?????

0 Kudos

any inputs friends?

0 Kudos

There is another option of using OLE automation Please check the link below

http://wiki.sdn.sap.com/wiki/display/Snippets/ABAP-OLEAutomationusing+MS-Excel

OR

chek for the example program in Tcode DWDM ( OLE example )

OR

Use FM KCD_EXCEL_OLE_TO_INT_CONVERT ( Fm Uses the same OLE automation)

Hope it helps

Anup