topic Excel cell format in Application Development and Automation Discussions

Excel cell format

Former Member — Mon, 19 May 2008 11:04:54 GMT

Good morning:

I am using the function SAP_CONVERT_TO_XLS_FORMAT for sending an internal table to excel sheet, but i have to send some numbers with 0 in the left and excel is deleting them because of the excel cell format, is there any fast way of doing it without using the oo methods for formating the cells, does anybody use any other way?..

Thanks in advance

regards

Points will be rewarded for vale answered

Re: Excel cell format

Former Member — Mon, 19 May 2008 11:12:25 GMT

you can put ' (apostofi ) before the required,

value.

excel wil accept this as like 01, 02.

if its works not conver it into text.

it will definatly works.

rewards are expected.

Re: Excel cell format

geetha_k — Mon, 19 May 2008 11:14:25 GMT

Hi,

In ur report , after executing the report u will click the PRINT PREVIEW button, and goto system~~>list~~>local file--->the u will select the radia button in which way to save the file.u will select select spreed sheet then save in xls format.. okk