alv output in html and in excel format

[Former Member]

hi all,

how can i get the alv output in excel sheet and also in html.

not dowloading but directly when i execute the report i need to get output in excel and in html format.

regards,

geetha

[Former Member]

Hi.

Have a look at this thread

[Former Member]

thanks you very much for your ans.

but what is OLE automation.

[Former Member]

Hi,

Refer to following link,

http://www.sap-img.com/abap/download-to-excel-with-format-border-color-cell-etc.htm

regards,

Dhan

[Former Member]

Thanks for your ans.but i need direct out in excel but not downloading

Ragards,

geetha

[Former Member]

hii

Use the Local file button on the toolbar of ALV.By clicking on this you will be able to export data in to excel sheet.

also refer to following link

If your requirement is to download data programetically then you can use

GUI_DOWNLOAD Function Module..

regards

twinkal

Edited by: twinkal patel on Jul 24, 2008 9:23 AM

[Former Member]

hi

to get the output direct in Excel u have to store output in an internal table and convert it into Execl thats the only option

for this use

GUI_download FM

Cheers

Snehi

[Former Member]

thank you.

Regards,

geetha