File download issue in 4.6

[Former Member]

Hi all,

I need to download a file from 4.6 version SAP system into Excel sheet with tab as a seperator, GUI_DOWNLOAD has no field seperator option in this version, is there any other FM to download this file into excel so that every field should be displayed in seperate cell in excel.

The download table iam using is daclared as

begin of i_downtab,

data(1000),

end of i_downtab.

Thanks in advance.

Sunny.

[Former Member]

Hi,

Try to download using function "WS_EXCEL ". which may solve your issue.

Cheers!!

[Former Member]

In WS_EXCEL also the total row is getting displayed in single cell.

i want evry field of a row to be displayed in a single cell of excel....

how can i get that .??

[former_member156446]

try

CALL FUNCTION 'XXL_FULL_API'
  EXPORTING
*   DATA_ENDING_AT          = 54
*   DATA_STARTING_AT        = 5
   filename                = 'TESTFILE'
   header_1                = header1
   header_2                = header2
   no_dialog               = 'X'
   no_start                = ' '
    n_att_cols              = 6
    n_hrz_keys              = 1
    n_vrt_keys              = 4
   sema_type               = 'X'
*   SO_TITLE                = ' '
  TABLES
    data                    = t_sflight
    hkey                    = t_hkey
    online_text             = t_online
    print_text              = t_print
    sema                    = t_sema
    vkey                    = t_vkey
 EXCEPTIONS
   cancelled_by_user       = 1
   data_too_big            = 2
   dim_mismatch_data       = 3
   dim_mismatch_sema       = 4
   dim_mismatch_vkey       = 5
   error_in_hkey           = 6
   error_in_sema           = 7
   file_open_error         = 8
   file_write_error        = 9
   inv_data_range          = 10
   inv_winsys              = 11
   inv_xxl                 = 12
   OTHERS                  = 13
          .
IF sy-subrc <> 0.
  MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
          WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ENDIF.