Function Module 'XXL_SIMPLE_API'

[Former Member]

Hi All,

I am using the function module 'XXL_SIMPLE_API' to download data into the excel sheet.

By using the function Module the data is getting displayed in the excel but when we close the excel sheet , it is not getting saved .

Thanks in advance

[Former Member]

Why dont you use GUI_DOWNLOAD instead? Search the forum, you will find lots of examples.

          CALL FUNCTION 'GUI_DOWNLOAD'
            EXPORTING
              filename                = l_floc         "File Path and name
              filetype                = 'DAT'
              write_field_separator   = ' '
            TABLES
              data_tab                = i_outputtab     " Output internal table
              fieldnames              = i_header        "Column Header
            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
              OTHERS                  = 22.

[Former Member]

Additional Info...

Earlier we were using the Function Module 'MS_EXCEL_OLE_STANDARD_DAT' nad we want to replace this as it has become obselete..

[Former Member]

'GUI_DOWNLOAD' is newer than 'XXL_SIMPLE_API'. You dont have to worry about GUI_DOWNLOAD being obsolete.

'XXL_SIMPLE_API'  was released in 1995
'GUI_DOWNLOAD' was released in 2001