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

Error while Exporting to Excel from ALV Report

Go to solution
former_member311223
Participant

‎2011 Mar 18 4:40 AM

0 Likes
1,581

Dear Experts,

When I am exporting my report output to an Excel Sheet directly some of the headers are appearing in Row No 1 and some are displaying in Row No. 2. Hence the corresponding values are also showing in the same manner.

I want to show all the Rows in a single row in row No 1. I am unable to find the solution for this.

But when I am exporting the same report into the MHTML Excel format the Report Headings are showing correctly in a single row and hence the respective values are also showing correctly in a single row. And if I save the same MHTML Excel as normal EXCEL(97-2003) format then also it is showing correctly.

The problem comes only when I as exporting it directly into EXCEL(97-2003) format.

Plz help.

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2011 Mar 18 4:45 AM

0 Likes
914

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.

Thanks

LG

Dear Experts,

When I am exporting my report output to an Excel Sheet directly some of the headers are appearing in Row No 1 and some are displaying in Row No. 2. Hence the corresponding values are also showing in the same manner.

I want to show all the Rows in a single row in row No 1. I am unable to find the solution for this.

But when I am exporting the same report into the MHTML Excel format the Report Headings are showing correctly in a single row and hence the respective values are also showing correctly in a single row. And if I save the same MHTML Excel as normal EXCEL(97-2003) format then also it is showing correctly.

The problem comes only when I as exporting it directly into EXCEL(97-2003) format.

Plz help.

Reply
3 REPLIES 3
Read only

Go to solution
Former Member

‎2011 Mar 18 4:45 AM

0 Likes
915

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.

Thanks

LG

Read only

Go to solution
former_member311223
Participant
In response to Former Member

‎2011 Mar 18 5:58 AM

0 Likes
914

Hi LG,

Thanx a lot for ur support.. as per ur resolution.. the issue is solved now...

Thanx LG and thanx SDN..

Regards

gopa

Read only

Go to solution
Former Member
In response to Former Member

‎2011 May 18 1:25 PM

0 Likes
914

'Hi,

I have a similar error.The data when exported from ALV to excel sheet gets deleted for just 1 column.Can you please suggest if we have a solution for this?

Thanks.