Download to excel

[former_member435532]

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

[Former Member]

hi Ajay,

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

thanks

[former_member435532]

Hi Rimpa,

Do we have any workaround or smarter way to achive this or it is not possible at all?

Regards/Ajay Dhyani

[Former Member]

hi ,

please check the below links for ur answer

thanks

[GauthamV]

Open your excel sheet - select all - right click - format cells - text - ok.

Now save your data in it, you will get leading zeros.

[Former Member]

Hello ajay,

It is possible in excle , see you are downloading ALV in excle , and excle is taking it as number , if you convert that cell into text then i will ale leading ZEROS.

Other way to do this is you have to get data in ALV in CHAR. format , and then download.

Regards

Shrikant

[former_member435532]

Hi All,

How do i change the column or cell level setting to char before upload?

Regards/Ajay

[former_member435532]

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.