topic Re: Formatting Excel Fields thru ABAP in Application Development and Automation Discussions

Formatting Excel Fields thru ABAP

Former Member — Fri, 05 May 2006 07:09:45 GMT

I want the Excel Cell to hold value 002. But If we enter the values thru the Program, it just displays 2. Tell me how to retain zeroes on the left. Ex: Account No. 000123456789.

Re: Formatting Excel Fields thru ABAP

Former Member — Fri, 05 May 2006 07:17:47 GMT

just open xls sheet.

right click on coloumn.

click format cells

select text option.

click ok.

now u can insert 002.

Re: Formatting Excel Fields thru ABAP

Former Member — Fri, 05 May 2006 07:34:19 GMT

Hi Venkat,

You need to change the property of the column to text else Excel cuts the leading zeros..

U can set it to text in the format cell option..

No change is required from the program end..

Regards,

Tanveer.

Please mark if found helpful..

Re: Formatting Excel Fields thru ABAP

Former Member — Fri, 05 May 2006 08:10:20 GMT

Give File type as 'WK1' in GUI_DOWNLOAD