download the data with zero value in excel file

[Former Member]

Dear Experts,

                    I am facing a problem while download the data of internal table to excel file and send the mail, The problem is in one field which contains 0172 value but in excel file show it 172 please help me.

Regards

Deepak Kumar

[Former Member]

Hi,

pass the value as '0172 instead of 172

check link aslo

[Former Member]

Hi Kiran,

             Thanks for reply but it show the value '0172 in excel file. if I am using this.

[Former Member]

Hi,

It should work in general, if you open the excel and try to put the any value with '0123' it will show as 0123.

check your value should pass to the variable as concatenate of value  '01766

Check once again

[former_member187748]

Hi Deepak,

i think its an excel issue, so can be removed by adding ' in your data.

i.e,

in place of  0120 use '0120, the output will be 0120 in excel

it will solve your issue.

[nabheetscn]

How are you downloading the excel file via function module?

[Former Member]

yes

[former_member187748]

Hi Deepak,

if still you have problems then please use OLE objects instead of GUI Download.

For use of OLE object , please see this link

ABAP OLE - Download tables to multiple worksheets in Excel - Code Gallery - SCN Wiki

[Former Member]

Dear Expert

      I went through your like but am not getting clear picture . kindly help me to  close this issue

Regards

Deepak

[former_member187748]

Hi Deepak,

if you haven't got your result, don't close the issue.

Please search about it in the forum, there are various post for the same purpose

you will get your result.

[Former Member]

Paste the code here, some one can help

[nabheetscn]

How are you downloading the file cna you please share the details

Nabheet