Data in Excel

[Former Member]

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

[former_member156446]

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..

[Former Member]

Jay,

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

Thank You.

Regards,

DhanaLakshmi M S

[former_member156446]

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]

Hi

try this method..code

call method CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD

[/code]

[Former Member]

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]

Hi Dhana

which FM r u using to download data into excel?

Cheers

shivika

[Former Member]

hi ,

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

[Former Member]

Thank you all.

DhanaLakshmi M S

[Former Member]

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.