topic Re: regarding problem while downloading excel in Application Development and Automation Discussions

regarding problem while downloading excel

Former Member — Wed, 14 May 2008 10:47:19 GMT

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

Re: regarding problem while downloading excel

Former Member — Wed, 14 May 2008 10:58:10 GMT

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.

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

Venkat

Re: regarding problem while downloading excel

Former Member — Wed, 14 May 2008 10:58:17 GMT

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

Re: regarding problem while downloading excel

Former Member — Wed, 14 May 2008 10:58:54 GMT

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

Re: regarding problem while downloading excel

Former Member — Wed, 14 May 2008 11:03:10 GMT

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.

Re: regarding problem while downloading excel

Former Member — Wed, 14 May 2008 11:19:18 GMT

hello guha,

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

thanks,

Suresh

Re: regarding problem while downloading excel

Former Member — Wed, 14 May 2008 11:33:14 GMT

Hi,

This is problem with the excel.

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

Reward points

Re: regarding problem while downloading excel

Former Member — Tue, 15 Nov 2011 05:29:18 GMT

This message was moderated.