Skip to Content
0
Former Member
Dec 08, 2006 at 05:25 AM

Need to Convert a TXT file into EXCEL

65 Views

Im using the function SAP_CONVERT_TO_TXT_FORMAT.

I want to convert the contents of wa_data to excel format.

IT is my internal table.

data: wa_data type TRUXS_T_TEXT_DATA.

form set_excel.

call function 'SAP_CONVERT_TO_TXT_FORMAT'

EXPORTING

  • I_FIELD_SEPERATOR =

I_LINE_HEADER = 'X'

  • I_FILENAME =

  • I_APPL_KEEP = ' '

tables

I_TAB_SAP_DATA = IT

CHANGING

I_TAB_CONVERTED_DATA = wa_data

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2

.

if SY-SUBRC <> 0.

  • MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

  • WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

endif.

DATA stmp(4096) TYPE c.

DATA itmp TYPE i.

LOOP AT wa_data INTO stmp.

itmp = STRLEN( stmp ).

stmp+itmp = cl_abap_char_utilities=>cr_lf.

MODIFY wa_data FROM stmp.

ENDLOOP.

endform.

Answers will be rewarded with points.

Message was edited by:

Manu Kapur