03-03-2011 9:16 AM
Hi All,
I am facing a strange problem while exporting my ALV output to Excel file.
I have copied a program for TCODE IW39 and added some fields to be displayed in ALV.
Everything is fine till ALV display.
But when I export my output to Excel, the columns are jumbling.
suppose I have 90 columns, in excel 70 columns are coming in one line and rest of them are coming in next line.
similarly the data as well.
Please help
Thanks in Advance
Lalit Gupta
03-05-2011 10:41 AM
Hi,
This is the Technical limitation of ABAP list export to local file.
ALV grid greater than 1023 characters per line will be split into 2 lines.
To prevent a line break occuring when you download the list as a local spreadsheet file, you must reduce the width of the list in ALV. You can do this either by hiding columns or by changing the column widths in the ALV. Take care that the column heading characters also dont exceed 1023 characters. This will work.
Regards,
Sonal
03-03-2011 10:15 AM
03-03-2011 10:24 AM
hi
I have copied it from IW39 and the export to excel button was not in menu/application bar.
I have added it manually and the option for save to local is not coming.
thanks
lalit
03-03-2011 10:28 AM
Please try with the following procedure.
In the ALV Grid Display you can find LIST in the menubar. Then go to export sub menu and then spreadsheet.
Then select the radio button Excel(in MHTML format) then press continue.Save the file in your desired location with default extension.I think your problem will be solved.
Regards,
Suvajit.
03-03-2011 10:30 AM
Hi
Buddy I can save the report in excel and i know how to export
but the problem is my columns in Excel are coming in jumble, they are not coming in one line.
i want them in one line
i hope you understand now.
thanks
lalit Gupta
03-03-2011 11:33 AM
Hi ,
Try downloading from some other computer, if it works fine then some problem with Excel on your computer.
03-05-2011 10:41 AM
Hi,
This is the Technical limitation of ABAP list export to local file.
ALV grid greater than 1023 characters per line will be split into 2 lines.
To prevent a line break occuring when you download the list as a local spreadsheet file, you must reduce the width of the list in ALV. You can do this either by hiding columns or by changing the column widths in the ALV. Take care that the column heading characters also dont exceed 1023 characters. This will work.
Regards,
Sonal
03-07-2011 3:50 AM