topic excel sheet convert in Application Development and Automation Discussions

excel sheet convert

Former Member — Tue, 05 Jan 2010 05:33:18 GMT

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

Re: excel sheet convert

viquar_iqbal — Tue, 05 Jan 2010 05:49:33 GMT

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

Re: excel sheet convert

Former Member — Tue, 05 Jan 2010 06:03:19 GMT

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.