Skip to Content
author's profile photo Former Member
Former Member

data not getting transfred to excel file .

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

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 09:14 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 09:12 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 09:21 AM

    hi,

    use any of these function modules

    GUI_DOWNLOAD

    WS_DOWNLOAD

    DOWNLOAD

    and,pass the parameters,

    i hope,you will get it,

    regards,

    kcc

    Add comment
    10|10000 characters needed characters exceeded