topic Problem when exporting ALV to Excel in Application Development and Automation Discussions

Problem when exporting ALV to Excel

Former Member — Wed, 14 Nov 2012 13:10:24 GMT

Hi experts,

We are facing a problem, strange for us. The ALV contents work fine when downloading the data to Excel in Quality system, whereas the format gets corrupted while downloading in Production. Some of the colums appear in new line. There are no pending transports. The number of columns in ALV is around 15-25. Could this be due to profile parameters or some system setting problem.

We also requested the user to try Excel in Place. Got the following message "the amount of data can not be processed in Excel".

All suggestion and inputs are appreciated.

Thanks & Regards

Jayanth

Re: Problem when exporting ALV to Excel

alex_campbell — Wed, 14 Nov 2012 21:03:02 GMT

What version of excel are the users using? Excel 2003 had a limitation of 256 columns. It's possible that if the file contains more columns than that, Excel wraps them to the next line. Also, the error message "The amount of data can not be processed in excel" hints at this as well. You might look at the code to see if there is a bug somehow causing the ALV to display more columns than the 15-25 which you expect it to display. Is the data table bieng generated dynamically?

Re: Problem when exporting ALV to Excel

Former Member — Wed, 14 Nov 2012 21:26:33 GMT

hello,

check this

SAP Note 855314 - Downloading a list from the ALV to

Excel

Note Language: English Version: 2 Validity: Valid Since 21.06.2005

Symptom

You download a list that is wider than 1023 characters from the ABAP List

Viewer (ALV) to a local file as a spreadsheet. A line break occurs after

1023 characters. The list appears in Excel in this way.

Other terms

Excel, download, lists, ALV, 1023 columns, list width

REUSE_ALV_LIST_DISPLAY, REUSE_ALV_GRID_DISPLAY, CL_GUI_ALV_GRID

Reason and Prerequisites

Solution

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.

best regards,

swanand