topic Re: Data in Excel in Application Development and Automation Discussions

Data in Excel

Former Member — Wed, 06 Feb 2008 04:38:25 GMT

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

Re: Data in Excel

former_member156446 — Wed, 06 Feb 2008 04:42:07 GMT

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

Re: Data in Excel

Former Member — Wed, 06 Feb 2008 04:43:50 GMT

try this method..code

call method CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD

[/code]

Re: Data in Excel

Former Member — Wed, 06 Feb 2008 04:44:09 GMT

Jay,

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

Thank You.

Regards,

DhanaLakshmi M S

Re: Data in Excel

Former Member — Wed, 06 Feb 2008 04:44:27 GMT

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

Re: Data in Excel

Former Member — Wed, 06 Feb 2008 04:44:32 GMT

Hi Dhana

which FM r u using to download data into excel?

Cheers

shivika

Re: Data in Excel

Former Member — Wed, 06 Feb 2008 04:44:45 GMT

hi ,

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

Re: Data in Excel

Former Member — Wed, 06 Feb 2008 04:49:57 GMT

Thank you all.

DhanaLakshmi M S

Re: Data in Excel

former_member156446 — Wed, 06 Feb 2008 04:53:37 GMT

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

Re: Data in Excel

Former Member — Wed, 06 Feb 2008 04:57:40 GMT

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.