topic Re: Alv in Application Development and Automation Discussions

Alv

Former Member — Mon, 07 May 2007 09:53:35 GMT

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

Re: Alv

Former Member — Mon, 07 May 2007 09:57:00 GMT

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

Re: Alv

Former Member — Mon, 07 May 2007 10:00:41 GMT

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

Re: Alv

sreeramkumar_madisetty — Mon, 07 May 2007 10:00:58 GMT

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

Re: Alv

Former Member — Mon, 07 May 2007 10:04:15 GMT

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

Re: Alv

Former Member — Mon, 07 May 2007 10:05:29 GMT

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

Re: Alv

Former Member — Mon, 07 May 2007 11:29:17 GMT

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

Re: Alv

Former Member — Mon, 07 May 2007 17:19:34 GMT

Hi,

Check the following link:

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

Regards,

Bhaskar

Re: Alv

Former Member — Wed, 30 May 2007 08:16:09 GMT

Thanks For All...

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