topic Re: GUI_DOWNLOAD in Application Development and Automation Discussions

GUI_DOWNLOAD

Former Member — Tue, 04 Dec 2007 19:43:11 GMT

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.

Re: GUI_DOWNLOAD

Former Member — Tue, 04 Dec 2007 19:46:31 GMT

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

Re: GUI_DOWNLOAD

Former Member — Tue, 04 Dec 2007 19:47:20 GMT

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

Re: GUI_DOWNLOAD

former_member194669 — Tue, 04 Dec 2007 19:48:04 GMT

Hi,

Call fm SAP_CONVERT_TO_CSV_FORMAT before calling GUI_DOWNLOAD

a®

Re: GUI_DOWNLOAD

Former Member — Tue, 04 Dec 2007 19:50:07 GMT

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

Re: GUI_DOWNLOAD

Former Member — Tue, 04 Dec 2007 20:01:43 GMT

Hi Tom,

Try this code....


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