cancel
Showing results for 
Search instead for 
Did you mean: 

ALV grid output issue to excel

Former Member
0 Kudos

Hi Experts

I have an ALV report which I want to Download to Excel( I am using excel 2003).

When I veiw the report it apperars ok. Their are around 90 columns in the Report

But when I export the alv I found that some columns are on the next line. Is there any way to resolve this issue

I want to export in excel without creating new rows of columns .

Thanks

Vikrant

View Entire Topic
mauro_bianchi
Active Contributor
0 Kudos

Hi Vikrant,

This is really a technical limitation of Abap list export to local file.

ALV Grid > 1023 characters per line will be split into 2 lines.

To prevent a line break occurring when you download the list as a local spreadsheet file, you must reduce the width of the list in the ALV.

You can do this either by hiding columns, or by changing the column widths in the ALV. Please see details in note below:

855314 - Downloading a list from the ALV to Excel

Regards,

Mauro

Former Member
0 Kudos

Deleted

Edited by: Gaurav.B on Sep 20, 2011 9:04 AM