2007 Aug 03 7:03 AM
Hi All,
I have a report which gives list output. When i download this into excel sheet,( by following system-> list -> save -> local file -> spreadsheet) i get the output in a haphazard manner. I need this in a proper manner in excel sheet.
My question is : If I convert the report output in to ALV format, will the output downloaded into excel format be in a proper and orderly fashion?
Thanks
Arun.
Hi All,
I have a report which gives list output. When i download this into excel sheet,( by following system-> list -> save -> local file -> spreadsheet) i get the output in a haphazard manner. I need this in a proper manner in excel sheet.
My question is : If I convert the report output in to ALV format, will the output downloaded into excel format be in a proper and orderly fashion?
Thanks
Arun.
2007 Aug 03 7:06 AM
Yes. ALV Output can be converted to Excel keeping the columns intact.
Please mark points if the solution was useful.
Regards,
Manoj
2007 Aug 03 7:21 AM
Hi,
There are button in the application tool bar ( Buttons as Spreadsheet - 12 button
Localfile -- 14 button )
u can use this 2 buttons when u choose, spreadsheet button , u have a option of downloading the data into 3 different ways like Pivot,table & macros.
i think , here u can download the desired date to the excel sheet.
Reward Points if it is Useful.
Thanks,
Manjunath MS