Problem using GUI_DOWNLOAD

[Former Member]

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

[athavanraja]

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

Regards

Raja

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi,

Can you tell me what is the expected value.

instead of 111111E2.

Lokesh

[Former Member]

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

[Former Member]

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

[former_member188685]

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]

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]

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