Skip to Content

Download to excel

Hi,

I am downloading ALV grid view data in to excel file.

THe problem i am facing is when i am download the content then i am passing idetifier for rows '00' , '02' etc.

after the download the preceding zero are getting trucncated.Is there any way that i can download the content in excel and it still retains the preceding zero for identifiers.

Regards/Ajay

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jul 09, 2009 at 05:42 AM

    hi Ajay,

    It is the property of excel ...so it deletes the leading zeros

    thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 12, 2009 at 06:53 AM

    Hi,

    It is possible to have leading zeroes in excel.

    My problem was that instead of putting '00' excel was putting '0' after download .

    Have passwed the below instead of '00' to the internal table and it worked.

    '=replace(" ",1,2,"00").

    but the problem was i have option of txt download also avilable for user so the whole command was appearing in the notepad.

    But it is possible to do it:->

    Most helpfull answer rewarded.

    Thanks a lot to everyone for you valuable inputs.

    Add comment
    10|10000 characters needed characters exceeded