Moin.Abapsocke hat geschrieben: Über git steht, das ich abap git installieren muss. Da muss ich auch anfragen ob ich das überhaupt in Frage kommt.
Vielleicht gibt es ja irgendwen der mit dem Framework erfahrung hat und mir das ein stück weit erklären kann.
Code: Alles auswählen.
DATA(lr_excel) = NEW zcl_excel( ).
" Convert ALV field catalog to Excel field catalog
DATA(lt_xl_fcat) = VALUE zexcel_t_fieldcatalog( ).
LOOP AT lt_fcat INTO DATA(ls_fcat).
APPEND INITIAL LINE TO lt_xl_fcat ASSIGNING FIELD-SYMBOL(<ls_xl_fcat>).
MOVE-CORRESPONDING ls_fcat TO <ls_xl_fcat>.
<ls_xl_fcat>-position = ls_fcat-col_pos.
<ls_xl_fcat>-dynpfld = abap_true.
ENDLOOP.
DATA(lr_ws) = lr_excel->get_worksheet_by_index( 1 ).
lr_ws->set_title( 'Test' ).
lr_ws->bind_table( EXPORTING
is_table_settings = VALUE #( top_left_row = 1 top_left_column = 'A' )
ip_table = lt_scope
it_field_catalog = lt_xl_fcat
IMPORTING
es_table_settings = DATA(ls_tab_set) ).
DATA(lr_xls_writer) = NEW zcl_excel_writer_2007( ).
DATA(lv_content) = lr_xls_writer->zif_excel_writer~write_file( ir_excel ).
DATA(lt_rawdata) = cl_bcs_convert=>xstring_to_solix( iv_xstring = lv_content ).
DATA(lv_bytecount) = xstrlen( lv_content ).
DATA:error TYPE REF TO i_oi_error,
t_errors TYPE STANDARD TABLE OF REF TO i_oi_error WITH NON-UNIQUE DEFAULT KEY,
cl_control TYPE REF TO i_oi_container_control, "OIContainerCtrl
cl_document TYPE REF TO i_oi_document_proxy. "Office Dokument
c_oi_container_control_creator=>get_container_control( IMPORTING control = cl_control
error = error ).
APPEND error TO t_errors.
cl_control->init_control( EXPORTING inplace_enabled = space
no_flush = 'X'
r3_application_name = 'Test'
parent = cl_gui_container=>screen0
IMPORTING error = error
EXCEPTIONS OTHERS = 2 ).
IF sy-subrc <> 0.
RETURN.
ENDIF.
APPEND error TO t_errors.
cl_control->get_document_proxy( EXPORTING document_type = 'Excel.Sheet' " EXCEL
no_flush = ' '
IMPORTING document_proxy = cl_document
error = error ).
APPEND error TO t_errors.
cl_document->open_document_from_table( EXPORTING document_size = lv_bytecount
document_table = lt_rawdata
document_title = 'Test'
open_inplace = space ).