Skip to Content
0
Former Member
Sep 17, 2008 at 09:26 AM

Down load report output from SAP to Excel sheet

39 Views

Hi,

Actually i am downloading report out into Excel sheet using FM GUI_LOAD. But in this case in Excel sheet we are getting the date format as *3/21/2008. But the requerment is the date format in Excel sheet should be display like 3/21/2008.So please advice me.

Code:

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = w-filename

filetype = 'DBF'

col_select = 'X'

col_select_mask = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'

wk1_n_format = 'X'

wk1_t_format = 'X'

DAT_MODE = 'X'

TABLES

data_tab = dtab_dat

fieldnames = htab.

Thanks in advance.

Regards,

Satya.