GUI_DOWNLOAD

[Former Member]

I only have four fields in itab. What params do I set in the FM so that each field is inits own colomn spreadsheet?

Thank-You.

[Former Member]

Set the WRITE_FIELD_SEPARATOR (in ECC6, I think it is different in other versions) to 'X'.

[Former Member]

Just call this FM as below

CALL FUNCTION 'GUI_DOWNLOAD'
EXPORTING
 FILENAME = 'C:test.xls'
 FILETYPE = 'ASC'
 WRITE_FIELD_SEPARATOR = 'X'
TABLES
 DATA_TAB = itab.

Regards,

Satish

[former_member194669]

Hi,

or

Call fm SAP_CONVERT_TO_CSV_FORMAT before calling GUI_DOWNLOAD

a®

[Former Member]

Hi Tom,

To download to excel you can use like this.

CALL FUNCTION 'GUI_DOWNLOAD'
  EXPORTING
    filename                        = 'c:tst.xls'
   FILETYPE                        = 'DAT'
  tables
    data_tab                        = i_mara.

Note: Please close the other thread ws_download.

Pavan

[Former Member]

Hi Tom,

Try this code....

CALL FUNCTION 'GUI_DOWNLOAD'
EXPORTING
 FILENAME = 'C:TEMPTEST.XLS'
 WRITE_FIELD_SEPARATOR = ';'
TABLES
 DATA_TAB = itab.