regarding problem while downloading excel

[Former Member]

Hi,

I m using GUi_download FM to download the data in XL format, it is downloading properly but only one problem is

there is one field called invoice number.

the length of this field is 40

and actual value is this 200793030022222

but wehn it download its coming like 2007+0154

is there any setting which we can chage this to normal value

if any let me know ..

Thanks,

Suresh

[Former Member]

Hi,

Its problem in xls.

Change the type of text to fraction... in xls. Select entire column, right click format cells... select fraction as type.

or

try changing that field type to character in the internal table and download.

Venkat

[Former Member]

Hi Suresh

Just change your InvoiceNumber field of your output table which you are passing to GUI_DOWNLOAD function module as data_tab parameter to type C of lenght 40 .

It will work.

Reward points if you find useful.

Regards,

Pranav.

Edited by: Pranav Satpute on May 14, 2008 12:59 PM

[Former Member]

Hi,

In the gui download their are two import parametrs

WK1_N_FORMAT

WK1_N_SIZE

Set the value for them.

Your problem will be solved.

Reward some points.

Regards,

Anomitro

[Former Member]

hello guha,

please let me know what value i can pass those 2 paramteres..

thanks,

Suresh

[Former Member]

it is the problem of excel when download is complete just dubble click on the field header of excel sheet or increment the width of the field it will show the real data.

[Former Member]

Hi,

This is problem with the excel.

Jus change the format of that column you will see the whole value.

Reward points

[Former Member]

This message was moderated.