Export ALV in EXCEL Issue

[Former Member]

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

[Former Member]

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

[Former Member]

Try using the save to local option and check if it is fine.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi ,

Try downloading from some other computer, if it works fine then some problem with Excel on your computer.

[Former Member]

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

[Former Member]

Thanks All

It is resolved now.