Conversion Problem when downloading to excel by using cl_abap_conv_out_ce

[Former Member]

Hi All,

We are download some date to excel by using the class

   CALL METHOD cl_abap_conv_out_ce=>create
            EXPORTING
              encoding = 'UTF-8'
            RECEIVING
              conv     = lo_utf8.

            CALL METHOD lo_utf8->write
            EXPORTING
              data = lv_string.

Every thing is fine but for some special character its not displaying properly. please find the below example

text = Chief Operating Officer – CIS

after down load to excel the special character is changed as mentioned below.

Chief Operating Officer – CIS

Is any way is there to solve this problem its very urgent Thanks in advance.

Thanks & Regards,

Hemachandran.R

[manigandan_d2]

Dear Hemachandran,

Please below logic to export the data excel,

CALL FUNCTION 'SCMS_STRING_TO_XSTRING'
EXPORTING
text = l_text
IMPORTING
buffer = l_xtext.

wdr_task=>client_window->client->attach_file_to_response(
i_filename = 'Report.xls'
i_content = l_xtext
i_mime_type = 'EXCEL'

).

Regards,

Manigandan D