12-04-2007 7:43 PM
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.
12-04-2007 7:46 PM
Set the WRITE_FIELD_SEPARATOR (in ECC6, I think it is different in other versions) to 'X'.
12-04-2007 7:46 PM
Set the WRITE_FIELD_SEPARATOR (in ECC6, I think it is different in other versions) to 'X'.
12-04-2007 7:47 PM
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
12-04-2007 7:48 PM
Hi,
or
Call fm SAP_CONVERT_TO_CSV_FORMAT before calling GUI_DOWNLOAD
a®
12-04-2007 7:50 PM
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
12-04-2007 8:01 PM
Hi Tom,
Try this code....
CALL FUNCTION 'GUI_DOWNLOAD'
EXPORTING
FILENAME = 'C:TEMPTEST.XLS'
WRITE_FIELD_SEPARATOR = ';'
TABLES
DATA_TAB = itab.