Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Problem when exporting ALV to Excel

Former Member

‎2012 Nov 14 1:10 PM

0 Likes
1,773

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

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

Reply
2 REPLIES 2
Read only

alex_campbell
Contributor

‎2012 Nov 14 9:03 PM

0 Likes
696

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?

Read only

Former Member

‎2012 Nov 14 9:26 PM

0 Likes
696

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