Skip to Content
author's profile photo Former Member
Former Member

Problem using GUI_DOWNLOAD

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2005 at 06:27 AM

    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 .

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2005 at 12:22 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2005 at 10:44 AM

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

    Regards

    Raja

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2005 at 10:50 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.