excel sheet convert

[Former Member]

when we convert to excel the first digit having zero is not properly convert and zero digit will appear in excel.

so, to get that zero when we convert to excel

thanks,

Tushar Barot

[viquar_iqbal]

Hi,

The workaround for that is use ' before 0. You need to check that if the first number is 0 and it doesnt contain any character ( ie . doesnt not contain sy-abcde) then concatenate ' with variable ( which contains 0 as first character) .

So when you download the excel youll get 0 displayed in excel.

If you want something permanent then use OLE concepts .

Thanks

Viquar Iqbal

[Former Member]

Use the Function module "SAP_CONVERT_TO_XLS_FORMAT".

with the parameters

I_FIELD_SEPERATOR = 'X'.

I_LINE_HEADER = 'X'.

I_FILENAME = "file name along with path"

I_TAB_SAP_DATA = "internal table you wanted to give as input"

rgds, manjunadh.