Skip to Content
0
Former Member
Feb 02, 2010 at 12:02 PM

Worksheet name in Excel

90 Views

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