Alv

[Former Member]

Hi All

I have a report which i have to print output in ALV_GRID display.But i have got more than 256 lines so i am not able to show it in output list.So i need to go to an EXCEL file while running the program.Is there any option without using OLE objects to go to excel directly .Is there any option in ALV to go to excel directly..I mean can i do this using any settings inside ALV. I dont want to use GUI_DOWNLOAD and all because i need to get direct Excel output ..Plz help.

Biju

[Former Member]

hi,

If you dont want to use the funciton modules that there is a button in the standard ALV menu which will help you to download the alv into the local file.

You can try that . hope this solves your problem.

Assing points if it helps.

-Gaurang

[Former Member]

Hi

Yes you are correct...But user dont want to press this button each and every time...He is running the report using transactin code so just by running this tcode he needs to see the Excel output...Here i am facing the problem...Plz help me..

Biju

[Former Member]

Hi

Use the function Modules

GUI_DOWNLOAD or

EXCEL_OLE_STANDARD_GET

pass the internal table with all fields in Char format

If you don't wants to use the fun modules

Use the Std menu Option Download to Spread Sheet.Excel.

Reward points if useful

Regards

Anji

[sreeramkumar_madisetty]

Hi

If you dont want to use the funciton modules that there is a button in the standard ALV menu which will help you to download the alv into the local file.

Regards,

Sreeram

[Former Member]

Hi Biju,

There a options in ALV in standard application toolbar having excel preview on it.

<b> Microsoft Excel View(CtrlshiftF7)</b>

U can use this button to do the same.

reward points if helpful.

Regards,

Hemant

[Former Member]

there is a button which is present in standard ALV toolbar.so we can click that.and download the file to excel sheet in local desktop.

reward with points if useful

[Former Member]

Hi,

Check the following link:

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

Regards,

Bhaskar

[Former Member]

Thanks For All...

I used Function-code and its working properly.......