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
Showing results for 
Search instead for 
Did you mean: 

Leading Zeroes get lost while downloading from BLOCK ALV

Former Member
0 Kudos

Hello Experts,

I have a problem while downloading excel from Block list ALV.

As Block ALV doent supprt direct Excel download option,i export it through Localfile->Spreadsheet.

But the leading zeroes get lost.

Kindly let me know a suitable solution to download leading zeroes too.

Thanks.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

goto first menu from left side, export -> html format...save it. it will open in excel

2 REPLIES 2

Former Member
0 Kudos

goto first menu from left side, export -> html format...save it. it will open in excel

arindam_m
Active Contributor
0 Kudos

Hi,

The zeroes vanish because of the excel formatting of the column. One way would be to display the values with type text when generating the excel. Other would be like downloading in Txt format and then doing a Text to columns in excel. Check the link below for more info.

http://support.microsoft.com/kb/214261

Also you can just transform the type of the column after download yourself. Just select column do Format cells and then custom and then give what ever is the fixed length you want say for example 00000. Then if there is 5 it will come as 00005 if its 99999 it will come like 99999 and so on.

Cheers,

Arindam