topic Problem using GUI_DOWNLOAD in Application Development and Automation Discussions

Problem using GUI_DOWNLOAD

Former Member — Sun, 04 Dec 2005 10:21:25 GMT

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

Re: Problem using GUI_DOWNLOAD

athavanraja — Sun, 04 Dec 2005 10:44:54 GMT

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

Regards

Raja

Re: Problem using GUI_DOWNLOAD

Former Member — Sun, 04 Dec 2005 10:50:12 GMT

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.

Re: Problem using GUI_DOWNLOAD

Former Member — Sun, 04 Dec 2005 11:12:44 GMT

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

Re: Problem using GUI_DOWNLOAD

Former Member — Sun, 04 Dec 2005 12:17:36 GMT

Hi,

Can you tell me what is the expected value.

instead of 111111E2.

Lokesh

Re: Problem using GUI_DOWNLOAD

Former Member — Sun, 04 Dec 2005 12:26:43 GMT

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

Re: Problem using GUI_DOWNLOAD

Former Member — Sun, 04 Dec 2005 16:38:36 GMT

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

Re: Problem using GUI_DOWNLOAD

Former Member — Mon, 05 Dec 2005 06:27:05 GMT

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 .

Re: Problem using GUI_DOWNLOAD

Former Member — Mon, 05 Dec 2005 06:47:23 GMT

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

Re: Problem using GUI_DOWNLOAD

Former Member — Mon, 05 Dec 2005 12:22:27 GMT

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