Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Downloading Special Character Data to EXCEL using ATTACH_FILE_TO_RESPONSE

Dear All

I have designed a Webdynpro application  where there is one Button-Download to Excel which downloads the internal table data into Excel file .xls

The Problem is: If Internal Table contains special character like ' " ' example "BRING TEXT in one of column  DESCRIPTION of internal table, the entire data in XLS file gets confined to one cell and the data below this row do not come in Excel file.

Piece of Code :

call function 'SCMS_STRING_TO_XSTRING'

    exporting

      text = l_input

      mimetype = 'APPLICATION/MSEXCEL'

    importing

      buffer = l_xstring.

* Attach file to respond

CALL METHOD cl_wd_runtime_services=>attach_file_to_response(

i_filename = l_c_filename

i_content = l_xstring

i_mime_type = l_c_excel ).



Please guide what needs to be done so that DESCRIPTION column if contains special character or simple english text everytime the data should be downloaded to XLS file in correct format.

Thanks !!

Former Member
Not what you were looking for? View more on this topic or Ask a question