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: 

Problem using GUI_DOWNLOAD

Former Member
0 Kudos

hi team,

I had used GUI_DOWNLOAD to download data to excel.

I had one field which i had declared it as char.

while downloading to excel the value is showing as 111111E+2. but i dont want like this , i want the whole number to be shown in the excel

pls help

1 ACCEPTED SOLUTION

Former Member
0 Kudos

this is the problem of excel .

when text of a cell is all of number ,e.g 111111111 ,

if the length of the cell is not enough, it will display like 1111E+5.

to resolve this problem ,you can set the length of the cell is enough .

you can do this also :

itab-fist = '111111111' .

CONCATENATE ''' itab-fist into itab-fist .

9 REPLIES 9

athavanraja
Active Contributor
0 Kudos

did you expand the excel column to full width and you still get this (111111E+2)?

Regards

Raja

Former Member
0 Kudos

Hi,

The problem is that the field value in the internal table you are passing to the FM GUI_DOWNLOAD is a floating field.

The Solution would be :

Before passing the values to the Internal table(to be passed to the FM GUI_DOWNLOAD), you need to convert this floating field to character value. You can use the FM FLTP_CHAR_CONVERSION for this purpose.

Hope this helps.

Lokesh

Please reward appropriate points.

0 Kudos

hi lokesh,

alredy i had declared the field as char(30).

so do i have to use the FM to convert it to char again

Can u please explain the import parameters which can be helpful to me

0 Kudos

Hi,

Can you tell me what is the expected value.

instead of 111111E2.

Lokesh

0 Kudos

Hi,

You still need to convert the Floating point field to Character value.

You can use the below logic to get the actual value,

Eg: Floating point field = 111111E+2

Char field = 111111 * (10)exp2 or [10 raise to the power 2]

This will work....

(please reward appropriate points)

Lokesh

0 Kudos

hi lokesh,

I had declared that as char, so no more it is floating point.

declared it as char(30).

In the excel sheet after downloading i want it as 11111111111 instead of 11111E6.

If i expand the excel also its not working

0 Kudos

Hi Chandra Sekhar,

I don't think there is problem with your code, try to expand the cells and see the data.

if you want to avod that uSe OLE ..

foe help check the examples on OLE...

regards

vijay

Former Member
0 Kudos

this is the problem of excel .

when text of a cell is all of number ,e.g 111111111 ,

if the length of the cell is not enough, it will display like 1111E+5.

to resolve this problem ,you can set the length of the cell is enough .

you can do this also :

itab-fist = '111111111' .

CONCATENATE ''' itab-fist into itab-fist .

Former Member
0 Kudos

Hi Chandrashekhar,

There is a setting that needs to be made in the excel file that u are downloading,

First select the entire excel sheet ,then

Go to format->cells and in category select TEXT , then ok.

Know if u download u will get the required format as required for your output .

Regards

Mustameer