data not getting transfred to excel file .

[Former Member]

hii frnds my requiremnet is that in a module pool program when the user is pressing the button 'tran' then the data of internal table will get transfered to the excel file .. well i have used the this logic but the data is not getting transfered to my excel file but only the file is created empty ..

IF saveok = 'TRAN' .

CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'

EXPORTING

• i_field_seperator = ','

• I_LINE_HEADER =

i_filename = 'D:\roh\CFORM1.xls'

• I_APPL_KEEP = ' '

TABLES

i_tab_sap_data = t_zcform.

ENDIF .

kindly help me if possible .

Thanking you

rohit gupta

[Former Member]

IF saveok = 'TRAN' .

CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'

EXPORTING

<b> i_field_seperator = ','

</b>* I_LINE_HEADER =

i_filename = 'D:\roh\CFORM1.xls'

• I_APPL_KEEP = ' '

TABLES

i_tab_sap_data = t_zcform.

[Former Member]

i believe you can use GUI_DOWNLOAD simply for this purpose.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

FILENAME = 'c:\abc.xls'

FILETYPE = 'ASC'

WRITE_FIELD_SEPARATOR = 'X'

TABLES

DATA_TAB = ITAB

.

it will work, i believe.

regards

srikanth

[Former Member]

thanks mr srikant the problem is solved .

[Former Member]

hi,

use any of these function modules

GUI_DOWNLOAD

WS_DOWNLOAD

DOWNLOAD

and,pass the parameters,

i hope,you will get it,

regards,

kcc