Application Development 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: 

Problem downloading ALV to Excel

Former Member

‎10-14-2008 2:09 PM

0 Kudos

Hi,

I have a ALV report, in that report one of the column is Vendor (LIFNR). In ALV it is displaying with leading zero. but when i download the report into Excel, the leading zero's are truncating. Could anybody let me know the solution for this. I want vendor numbers should be downloaded with leading zeros.

thanks in advance.

regards,

Sadiq

6 REPLIES 6

former_member181995
Active Contributor

‎10-14-2008 2:11 PM

0 Kudos

refer:

filetype = 'DBF'"should be there

Former Member
In response to former_member181995

‎10-14-2008 2:15 PM

0 Kudos

Hi,

I am not handling download functionality in my program. It is already there in ALV output screen. From ALV output screen iam trying to download as excel.

former_member181995
Active Contributor
In response to former_member181995

‎10-14-2008 2:29 PM

0 Kudos

than might be you need to do some setting like:

http://www.automateexcel.com/2004/10/03/excel_keep_leading_zeros/

Former Member

‎10-14-2008 2:14 PM

0 Kudos

Hi

The problem is on Excel, not SAP.

The vendor code is a number for excel, so it deletes the leading zero, u should download the vendor code in a text cell, in this way Excel mantains the format.

Max

Former Member

‎10-14-2008 3:10 PM

0 Kudos

hi,

You have to do something at excel side.

Pawan_Kesari
Active Contributor

‎10-14-2008 4:10 PM

0 Kudos

Try this option from menu on ALV Screen

List->Export->Speadsheet

then save the file