Create *XLSX files

[lydia_martinezmartinez]

Hi experts,

I want to create a file with the extension XLSX, but I can't.

I'm using the code:

   CALL METHOD cl_gui_frontend_services=>gui_download
      EXPORTING
        filename                = l_file
        filetype                = 'DAT'
      CHANGING
        data_tab                = t_data[]
      EXCEPTIONS
        file_write_error        = 1
        no_batch                = 2
        gui_refuse_filetransfer = 3
        invalid_type            = 4
        no_authority            = 5
        unknown_error           = 6
        header_not_allowed      = 7
        separator_not_allowed   = 8
        filesize_not_allowed    = 9
        header_too_long         = 10
        dp_error_create         = 11
        dp_error_send           = 12
        dp_error_write          = 13
        unknown_dp_error        = 14
        access_denied           = 15
        dp_out_of_memory        = 16
        disk_full               = 17
        dp_timeout              = 18
        file_not_found          = 19
        dataprovider_exception  = 20
        control_flush_error     = 21
        not_supported_by_gui    = 22
        error_no_gui            = 23
        OTHERS                  = 24.

But this method doesn't work correctly. Only It's work for XLS files.

Can anyone help me????

Thanks!!!

[Former Member]

Hi,

Try ABA2XLSX - http://wiki.sdn.sap.com/wiki/display/ABAP/abap2xlsx

Regards,

Chen