topic Re: Load File in Application Development and Automation Discussions

Load File

Former Member — Fri, 07 Jul 2006 08:19:20 GMT

Hi,

Can anyone help to export ALV report to EXCEL .Can we use Load_File Icon to do this.Pls help with this option.From where i can get that LOAD FILE icon?

Pls help

Ram

Re: Load File

Former Member — Fri, 07 Jul 2006 08:23:07 GMT

Exporting ALV output to EXCEL is a standard feature available in ALV. U need to use the List-Spreeadsheet option from the menu bar if u r using the REUSE function for ALV OR choose the EXPORT icon on the grid toolbar if u r using the OOPS concept for ALV.

-Kiran

Re: Load File

Former Member — Fri, 07 Jul 2006 08:33:23 GMT

In th application tool bar Export button(Green color with Arrow mark) is there.

Click that buuton. In that give the spread sheet option. then it will be downloaded all the data in the EXcel sheet.

Re: Load File

Laxmana_Appana_ — Fri, 07 Jul 2006 08:40:59 GMT

Hi,

Follow the below procedures to export data to excel.

Normal ALV :

Click on the local file option and select spreadsheet option from the radio button list and click on ok , file save window will open , select the correct directory path and give the file name , then ALV contents will be downloaded into Excel sheet.

In OO ALV :

click on the Export button in the ALV toolbar ->click on the spreadsheet , then information message window will open , select ok button , then you will get three options , click on the table option and press ok , data will be exported to Excel sheet , then save the excel data in specified directory.

Regards

Laxman