REPORT zjp_excel.
SELECT * FROM sbook INTO TABLE @DATA(it_out_rec).
DATA(lv_xls_file) = '/tmp/Bookings.xlsx'.
GET REFERENCE OF it_out_rec INTO DATA(lo_data_ref).
DATA(lv_xstring) = NEW zcl_itab_to_excel( )->itab_to_xstring( lo_data_ref ).
OPEN DATASET lv_xls_file FOR OUTPUT IN BINARY MODE.
IF sy-subrc EQ 0.
TRANSFER lv_xstring TO lv_xls_file.
CLOSE DATASET lv_xls_file.
ENDIF.
Serkan AKKAVAK
Computer Engineer BSc
Head of SAP & Software Department
Contact : serkurumsal@yandex.com
0 Comments