cancel
Showing results for 
Search instead for 
Did you mean: 

Worksheet name in Excel

luscruz
Participant
0 Kudos
145

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

Accepted Solutions (1)

Accepted Solutions (1)

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

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.

Answers (0)