download to excel from front end - percent coming as date

[Former Member]

download to excel from front end - percent coming as date

Hi,

i'm using below method to dowload to excel from frontend (Backened is R/3).

1) l_string will have the entire xls date ( with sepeartor cl_abap_char_utilities=>horizontal_tab and cl_abap_char_utilities=>newline)

2) Converitng string to xstring using FM SCMS_STRING_TO_XSTRING

3) pumping excel date to browser using IF_HTTP_ENTITY~SET_DATA

4) creating URL using GUID_CREATE fm.

it's downloding the excel file but funny date.

example

percentage 1.5 coming as Jan 50 and Percent 3.5 coming March 50.

How to avoid this funny conversion.

...Nandha

[Former Member]

file error.

[steffen_weber]

Hi Nanda,

have you tried to change the number format of the corresponding cells in excel to percentage?

BR Steffen