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: 

Data in Excel

Former Member
0 Kudos
99

Hi,

I have a requirement in such a way that the data in the internal table should be loaded into excel in the same format what the internal table has. Everything is fine, except the value 0000001, which is getting displayed in excel sheet as 1. What should be done to display the data 0000001 in excel sheet. How to format the excel sheet before loading the data.

Please help me out.

Thank you.

Regards,

DhanaLakshmi M S

1 ACCEPTED SOLUTION

former_member156446
Active Contributor
0 Kudos
72

actually the data will be loaded with padding zeros, its the issue with Excell which wont show the zeros.. open your file with text pad or any other tool .. you can see them..

9 REPLIES 9

former_member156446
Active Contributor
0 Kudos
73

actually the data will be loaded with padding zeros, its the issue with Excell which wont show the zeros.. open your file with text pad or any other tool .. you can see them..

0 Kudos
72

Jay,

Thanks for your reply. But is there any other way to format excel sheet?

Thank You.

Regards,

DhanaLakshmi M S

0 Kudos
72

check this links..

http://www.sap-img.com/abap/download-to-excel-with-format-border-color-cell-etc.htm

-


Select format cells (ctrl + 1).

Select custom format

and enter 0000000000

-


Former Member
0 Kudos
72

Hi

try this method..code

call method CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD

[/code]

Former Member
0 Kudos
72

do one thing that in your internal table take a separate field as character in place of field you want to print as 00001

now u have to populate this new field by this FM

*CONVERSION_EXIT_ALPHA_INPUT *

give your old field as input to it..........

it bconverts any number into a string fill with zeroes, with the number at the extreme right.

THEN TAKE OUTPUT YOUR PROBLEM WILL B SOLVED

PLZ REWARD IF USEFUL

KEEP ROCKIN

vivek

Former Member
0 Kudos
72

Hi Dhana

which FM r u using to download data into excel?

Cheers

shivika

Former Member
0 Kudos
72

hi ,

open that excel in .txt format u can see that Zeros.

Former Member
0 Kudos
72

Thank you all.

DhanaLakshmi M S

Former Member
0 Kudos
72

Hi, try this..

open the excel sheet and select the cell which u want exact value as u entered in the report ( ex 00023) and right click go for formatecell and select number in that select text then u will get exact what u had entered in the report..

regards,

Kavitha.