Worksheet name in Excel

[luscruz]

Hi all,

I have a Web Dynpro where is possible to download an excel file. But now I need to change the name of the worksheet.

Can anyone help me?

CALL FUNCTION 'SCMS_STRING_TO_XSTRING'
    EXPORTING
      text      = lv_text
      mimetype  = 'APPLICATION/MSEXCEL'
      encoding  = '1160' " Tabela: TCP00 CPCOMPANY = ISO
    IMPORTING
      buffer    = lv_xtext.

  wdr_task=>client_window->client->attach_file_to_response(
    i_filename = 'Lista_Horas.xls'
    i_content =  lv_xtext
    i_mime_type = 'EXCEL' ).

Best regards,

Luis Cruz

[thomas_jung · Accepted solution]

Since you are using 'SCMS_STRING_TO_XSTRING' I assume you build a text-tab delimited string for the Excel content. With the text-tab delimited format you have no formatting options or Excel specific functionality. You can't rename or use multiple worksheets. For that level of Excel specific functionality you would have to use the Excel XML format.