07-07-2006 9:19 AM
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
07-07-2006 9:40 AM
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
07-07-2006 9:23 AM
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
07-07-2006 9:33 AM
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.
07-07-2006 9:40 AM
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