首页 > 其他分享 >ABAP:接口文档下载

ABAP:接口文档下载

时间:2024-01-15 14:23:34浏览次数:24  
标签:ld excel 接口 col ABAP 文档 TYPE id row

*&---------------------------------------------------------------------*
*& Report ZTEST_RFC
*&---------------------------------------------------------------------*
*&
*&---------------------------------------------------------------------*
REPORT ztest_rfc LINE-SIZE 255..

*&---------------------------------------------------------------------*
*& Report  YLB011
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*


INCLUDE yfunc_excel.


TYPE-POOLS : rmdi.
**********************************************************************
*Define Types
**********************************************************************
TYPES: BEGIN OF ts_func,
         parameter  TYPE fupararef-parameter,  "参数名称
         paramtype  TYPE fupararef-paramtype,  "参数类型
         structure  TYPE fupararef-structure,  "接口参数的参考类型
         defaultval TYPE fupararef-defaultval, "输入参数的缺省值
         optional   TYPE fupararef-optional,   "可选参数
         pposition  TYPE fupararef-pposition, "表格行
         stext      TYPE funct-stext,          "短文本
       END OF ts_func,
       tt_func TYPE TABLE OF ts_func.

**********************************************************************
*Global Data
**********************************************************************
DATA: gt_func  TYPE tt_func,
      gt_imp   TYPE tt_func,
      gt_exp   TYPE tt_func,
      gt_cha   TYPE tt_func,
      gt_tab   TYPE tt_func,
      gt_struc TYPE tt_func.

DATA: gt_dd07v TYPE TABLE OF dd07v.

DATA: go_excel TYPE REF TO lcl_excel.
**********************************************************************
* SELECTION-SCREEN
**********************************************************************
PARAMETERS: p_fname LIKE fupararef-funcname.

SELECTION-SCREEN SKIP 1.
SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE TEXT-001.
  PARAMETER p_xls AS CHECKBOX.
  PARAMETER p_dir TYPE string.

  SELECTION-SCREEN SKIP 1.
  PARAMETER p_yh AS CHECKBOX.
SELECTION-SCREEN END OF BLOCK b1.


INITIALIZATION.
  p_xls = 'X'.
  CALL METHOD cl_gui_frontend_services=>get_desktop_directory
    CHANGING
      desktop_directory    = p_dir
    EXCEPTIONS
      cntl_error           = 1
      error_no_gui         = 2
      not_supported_by_gui = 3
      OTHERS               = 4.
  CALL METHOD cl_gui_cfw=>update_view.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_dir.
  CALL METHOD cl_gui_frontend_services=>directory_browse
*    EXPORTING
*      window_title         =
*      initial_folder       =
    CHANGING
      selected_folder      = p_dir
    EXCEPTIONS
      cntl_error           = 1
      error_no_gui         = 2
      not_supported_by_gui = 3
      OTHERS               = 4.



START-OF-SELECTION.
  PERFORM get_ddic_datatype.

  PERFORM get_func_para USING p_fname gt_func.
  PERFORM classify_func USING gt_func
                                gt_imp
                                gt_exp
                                gt_cha
                                gt_tab.

  PERFORM write_list.

  IF p_xls = 'X'.
    PERFORM download_template.
    LEAVE LIST-PROCESSING.
  ENDIF.

*&---------------------------------------------------------------------*
*&      Form  write_list
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM write_list.
  PERFORM write_head.
  PERFORM write_para USING '输入'  gt_imp gt_struc.
  PERFORM write_para USING '输出'  gt_exp gt_struc.
  PERFORM write_para USING '修改'  gt_cha gt_struc.
  PERFORM write_para USING '表'    gt_tab gt_struc.

  PERFORM write_sturc USING gt_struc.
ENDFORM.                    "write_list

*&---------------------------------------------------------------------*
*&      Form  download_template
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM download_template.
  DATA: ld_row TYPE i.


  DATA: ld_xls_file TYPE string.
  CONCATENATE p_dir '\' p_fname '_' sy-datum '.xls' INTO ld_xls_file.
  CREATE OBJECT go_excel
    EXPORTING
      id_xlsfile = ld_xls_file.

  PERFORM write_head_xls.

  ld_row = 2.
  PERFORM write_para_xls USING '输入' ld_row gt_imp.
  PERFORM write_para_xls USING '输出' ld_row gt_exp.
  PERFORM write_para_xls USING '修改' ld_row gt_cha.
  PERFORM write_para_xls USING '表 '  ld_row gt_tab.

  PERFORM write_sturc_xls USING ld_row gt_struc.
  DO 8 TIMES.
    go_excel->set_col_width( id_col_no = sy-index ).
  ENDDO.

  IF p_yh = 'X'.
    go_excel->select_range( id_range = 'A:H' ).
    go_excel->set_range_format( id_font_name = '微软雅黑' ).
  ENDIF.


  go_excel->frozen_window( id_row_no = 3 ).
  go_excel->save( ).
ENDFORM.                    "download_template


*&---------------------------------------------------------------------*
*&      Form  write_head_xls
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM write_head_xls.
  go_excel->rename_sheet( id_pos = 1 id_sheetname = p_fname ).
  go_excel->set_cell_data( id_col = 1 id_row = 1 id_value = '函数名' ).
  go_excel->set_cell_format( id_col = 1 id_row = 1 id_bold = 1  id_bg_color = 37 ).
  go_excel->set_cell_data( id_col = 2 id_row = 1 id_value = p_fname ).

  DATA: ld_stext TYPE tftit-stext.
  SELECT SINGLE stext INTO ld_stext FROM tftit WHERE funcname = p_fname.
  IF sy-subrc = 0.
    go_excel->set_cell_data( id_col = 5 id_row = 1 id_value = ld_stext ).
  ENDIF.

  DATA: ld_date TYPE char20,
        ld_time TYPE char20.

  WRITE sy-datum TO ld_date.
  WRITE sy-uzeit TO ld_time.
  CONCATENATE ld_date ld_time INTO ld_date SEPARATED BY space.

  go_excel->set_cell_data( id_col = 8 id_row = 1 id_value = ld_date ).

  go_excel->set_cell_data( id_col = 1 id_row = 2 id_value = '参数名' ).
  go_excel->set_cell_data( id_col = 2 id_row = 2 id_value = '类型' ).
  go_excel->set_cell_data( id_col = 3 id_row = 2 id_value = '长度' ).
  go_excel->set_cell_data( id_col = 4 id_row = 2 id_value = '小数' ).
  go_excel->set_cell_data( id_col = 5 id_row = 2 id_value = '描述文本' ).
  go_excel->set_cell_data( id_col = 6 id_row = 2 id_value = '可选' ).
  go_excel->set_cell_data( id_col = 7 id_row = 2 id_value = '默认值' ).
  go_excel->set_cell_data( id_col = 8 id_row = 2 id_value = '备注' ).

  go_excel->select_range( id_range = 'A2:H2' ).
  go_excel->set_range_format( id_bg_color = 37 ).
ENDFORM.                    "write_head_xls
*&---------------------------------------------------------------------*
*&      Form  write_para_xls
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->ID_PTYPE   text
*      -->CD_ROW     text
*      -->IT_PARA    text
*----------------------------------------------------------------------*
FORM write_para_xls USING id_ptype
                          cd_row
                          it_para TYPE tt_func.
  CHECK it_para IS NOT INITIAL.
  cd_row = cd_row + 2.

  go_excel->set_cell_data(  id_col = 1 id_row = cd_row id_value = id_ptype ).
  go_excel->set_cell_format( id_col = 1 id_row = cd_row id_bold = 1  id_bg_color = 37 ).

  DATA: ls_para TYPE ts_func.
  LOOP AT it_para INTO ls_para.
    cd_row = cd_row + 1.
    go_excel->set_cell_data( id_col = 1 id_row = cd_row id_value = ls_para-parameter ).

    PERFORM write_ddic_info_xls USING cd_row ls_para-structure.

    go_excel->set_cell_data( id_col = 5 id_row = cd_row id_value = ls_para-stext ).
    go_excel->set_cell_data( id_col = 6 id_row = cd_row id_value = ls_para-optional ).
    go_excel->set_cell_data( id_col = 7 id_row = cd_row id_value = ls_para-defaultval ).

  ENDLOOP.
ENDFORM.                    "write_para_xls
*&---------------------------------------------------------------------*
*&      Form  get_ddic_datatype
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM get_ddic_datatype.
  CALL FUNCTION 'DDUT_DOMVALUES_GET'
    EXPORTING
      name          = 'DATATYPE'
*     LANGU         = SY-LANGU
*     TEXTS_ONLY    = ' '
    TABLES
      dd07v_tab     = gt_dd07v
    EXCEPTIONS
      illegal_input = 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.

  SORT gt_dd07v BY domvalue_l.
ENDFORM.                    "get_ddic_datatype
*&---------------------------------------------------------------------*
*&      Form  get_func_para
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->ID_FUNCNAME  text
*      -->ET_FUNC      text
*----------------------------------------------------------------------*
FORM get_func_para USING id_funcname
                         et_func TYPE tt_func.
  SELECT
      fupararef~parameter         "参数名称
      fupararef~paramtype         "参数类型
      fupararef~structure         "接口参数的参考类型
      fupararef~defaultval        "输入参数的缺省值
      fupararef~optional          "可选参数
      fupararef~pposition
      funct~stext                 "短文本
  FROM fupararef INNER JOIN funct
  ON funct~funcname  = fupararef~funcname AND
         funct~parameter = fupararef~parameter AND
         funct~spras     = sy-langu
  INTO TABLE et_func
  WHERE fupararef~funcname = id_funcname AND
          r3state = 'A'.
  IF sy-subrc <> 0.
    MESSAGE '无法识别的函数名' TYPE 'S' DISPLAY LIKE 'E'.
    LEAVE LIST-PROCESSING.
  ENDIF.

ENDFORM.                    "get_func_para

*&---------------------------------------------------------------------*
*&      Form  classify_func
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->IT_FUNC    text
*      -->ET_IMP     text
*      -->ET_EXP     text
*      -->ET_CHA     text
*      -->ET_TAB     text
*----------------------------------------------------------------------*
FORM classify_func USING it_func TYPE tt_func
                         et_imp TYPE tt_func
                         et_exp TYPE tt_func
                         et_cha TYPE tt_func
                         et_tab TYPE tt_func.
  DATA: ls_func TYPE ts_func.

  LOOP AT it_func INTO ls_func.
    CASE ls_func-paramtype .
      WHEN 'I'.
        APPEND ls_func TO et_imp.
      WHEN 'E'.
        APPEND ls_func TO et_exp.
      WHEN 'C'.
        APPEND ls_func TO et_cha.
      WHEN 'T'.
        APPEND ls_func TO et_tab.
    ENDCASE.
  ENDLOOP.

  SORT et_imp BY pposition.
  SORT et_exp BY pposition.
  SORT et_cha BY pposition.
  SORT et_tab BY pposition.
ENDFORM.                    "classify_func
*&---------------------------------------------------------------------*
*&      Form  write_head
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->ID_PTYPE   text
*      -->IT_PARA    text
*      -->CT_STRUC   text
*----------------------------------------------------------------------*
FORM write_head .
  WRITE: /(30) '函数名',
  (40) p_fname ,
  (10)  ''  ,
  (10)  '',
  (40) '',
  (5)  '',
  (20) '',
  (20) ''.

  SKIP 1.
  WRITE: /(30) '参数名',
  (20) '类型'  ,
  (10)  '长度'  ,
  (10)  '小数'  ,
  (40) '描述文本',
  (5)  '可选',
  (20) '默认值',
  (20) '备注'.
  WRITE sy-uline.
ENDFORM.                    "write_head
*&---------------------------------------------------------------------*
*&      Form  write_para
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->ID_PTYPE   text
*      -->IT_PARA    text
*      -->CT_STRUC   text
*----------------------------------------------------------------------*
FORM write_para USING id_ptype
                      it_para TYPE tt_func
                      ct_struc TYPE tt_func.
  CHECK it_para IS NOT INITIAL.
  FORMAT INTENSIFIED COLOR = 5.
  WRITE :/(30) id_ptype.
  FORMAT INTENSIFIED COLOR = 0.

  DATA: ls_para       TYPE ts_func,
        ld_x_struc(1).
  LOOP AT it_para INTO ls_para.
    WRITE: /(30) ls_para-parameter     .

    CLEAR ld_x_struc.
    PERFORM write_ddic_info USING ls_para-structure
                                      ld_x_struc.
    IF ld_x_struc = 'X'.
      APPEND ls_para TO ct_struc.
    ENDIF.

    WRITE : (40) ls_para-stext         ,
    (5)  ls_para-optional      ,
    (20) ls_para-defaultval  .
  ENDLOOP.
  SKIP 2 .
ENDFORM.                    "write_para

*&---------------------------------------------------------------------*
*&      Form  write_ddic_info
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->ID_DATA    text
*      -->ED_X_STRUC text
*----------------------------------------------------------------------*
FORM write_ddic_info USING id_data
                           ed_x_struc.
  DATA: ld_match(1).
  CHECK id_data IS NOT INITIAL.
  IF id_data CS '-'.
    "参考字段
    PERFORM get_ddic_ref_field USING id_data.
  ELSE.
    "按照数据元素处理
    PERFORM get_ddic_data_element USING id_data ld_match.

    "不是field  默认按照structure 处理
    CHECK ld_match = ''.
    ed_x_struc = 'X'.
    WRITE: (20) id_data,
    (10) '',
    (10) ''.
  ENDIF.
ENDFORM.                    "write_ddic_info

*&---------------------------------------------------------------------*
*&      Form  write_ddic_info_xls
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->ID_ROW     text
*      -->ID_DATA    text
*----------------------------------------------------------------------*
FORM write_ddic_info_xls USING id_row TYPE i
                               id_data.
  DATA: ld_match(1).
  CHECK id_data IS NOT INITIAL.
  IF id_data CS '-'.
    "参考字段
    PERFORM get_ddic_ref_field_xls USING id_row
                                             id_data.
  ELSE.
    "按照数据元素处理
    PERFORM get_ddic_data_element_xls USING id_row id_data ld_match.

    "不是field  默认按照structure 处理
    CHECK ld_match = ''.

    go_excel->set_cell_data( id_col = 2 id_row = id_row id_value = id_data ).





  ENDIF.
ENDFORM.                    "write_ddic_info_xls


*&---------------------------------------------------------------------*
*&      Form  get_ddic_ref_field
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->ID_DATA    text
*----------------------------------------------------------------------*
FORM get_ddic_ref_field USING id_data.
  DATA: ld_tabname   TYPE rmdi_name,
        ld_fieldname TYPE rmdi_fienm,
        ls_field     TYPE rmdi_tabfld.
  SPLIT id_data AT '-' INTO ld_tabname ld_fieldname.
  CALL FUNCTION 'RM_TABLE_INFO_GET'
    EXPORTING
      i_tabname    = ld_tabname
      i_fieldname  = ld_fieldname
      i_langu      = sy-langu
      i_read_texts = 'X'
    IMPORTING
*     E_TABHEADER  =
      e_tabfield_w = ls_field
*     E_TABFIELDS_T       =
    EXCEPTIONS
      not_found    = 1
      ddic_error   = 2
      OTHERS       = 3.
  IF sy-subrc = 0.
    WRITE:
    (20) ls_field-datatype,
    (10)  ls_field-leng.
    IF ls_field-decimals IS INITIAL.
      WRITE (10)  ''.
    ELSE.
      WRITE (10)  ls_field-decimals.
    ENDIF.
  ENDIF.


ENDFORM.                    "get_ddic_ref_field


*&---------------------------------------------------------------------*
*&      Form  get_ddic_ref_field_xls
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->ID_ROW     text
*      -->ID_DATA    text
*----------------------------------------------------------------------*
FORM get_ddic_ref_field_xls USING id_row id_data.
  DATA: ld_tabname   TYPE rmdi_name,
        ld_fieldname TYPE rmdi_fienm,
        ls_field     TYPE rmdi_tabfld.
  SPLIT id_data AT '-' INTO ld_tabname ld_fieldname.
  CALL FUNCTION 'RM_TABLE_INFO_GET'
    EXPORTING
      i_tabname    = ld_tabname
      i_fieldname  = ld_fieldname
      i_langu      = sy-langu
      i_read_texts = 'X'
    IMPORTING
*     E_TABHEADER  =
      e_tabfield_w = ls_field
*     E_TABFIELDS_T       =
    EXCEPTIONS
      not_found    = 1
      ddic_error   = 2
      OTHERS       = 3.
  IF sy-subrc = 0.
    go_excel->set_cell_data( id_col = 2 id_row = id_row id_value = ls_field-datatype ).
    go_excel->set_cell_data( id_col = 3 id_row = id_row id_value = ls_field-leng ).

    IF ls_field-decimals IS NOT INITIAL.
      go_excel->set_cell_data( id_col = 4 id_row = id_row id_value = ls_field-decimals ).
    ENDIF.
  ENDIF.

ENDFORM.                    "get_ddic_ref_field_xls


*&---------------------------------------------------------------------*
*&      Form  get_ddic_data_element
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->ID_DATA    text
*      -->ED_MATCH   text
*----------------------------------------------------------------------*
FORM get_ddic_data_element USING id_data
                                 ed_match.

  DATA: ls_dd04v TYPE dd04v.
  DATA: ld_name TYPE ddobjname.
  ld_name = id_data.
  CALL FUNCTION 'DDIF_DTEL_GET'
    EXPORTING
      name          = ld_name
*     STATE         = 'A'
*     LANGU         = ' '
    IMPORTING
*     GOTSTATE      =
      dd04v_wa      = ls_dd04v
*     TPARA_WA      =
    EXCEPTIONS
      illegal_input = 1
      OTHERS        = 2.
  IF ls_dd04v-datatype IS NOT INITIAL.
    WRITE:
    (20) ls_dd04v-datatype,
    (10)  ls_dd04v-leng.
    IF ls_dd04v-decimals IS INITIAL.
      WRITE (10)  ''.
    ELSE.
      WRITE (10)  ls_dd04v-decimals.
    ENDIF.
    ed_match = 'X'.
  ELSE.
    READ TABLE gt_dd07v TRANSPORTING NO FIELDS WITH KEY domvalue_l = id_data
    BINARY SEARCH.
    IF sy-subrc = 0.
      ed_match = 'X'.
    ENDIF.
  ENDIF.

ENDFORM.                    "get_ddic_data_element


*&---------------------------------------------------------------------*
*&      Form  get_ddic_data_element_xls
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->ID_ROW     text
*      -->ID_DATA    text
*      -->ED_MATCH   text
*----------------------------------------------------------------------*
FORM get_ddic_data_element_xls USING id_row TYPE i
                                     id_data
                                     ed_match.
  DATA: ls_dd04v TYPE dd04v.
  DATA: ld_name TYPE ddobjname.
  ld_name = id_data.
  CALL FUNCTION 'DDIF_DTEL_GET'
    EXPORTING
      name          = ld_name
*     STATE         = 'A'
*     LANGU         = ' '
    IMPORTING
*     GOTSTATE      =
      dd04v_wa      = ls_dd04v
*     TPARA_WA      =
    EXCEPTIONS
      illegal_input = 1
      OTHERS        = 2.
  IF ls_dd04v-datatype IS NOT INITIAL.
    go_excel->set_cell_data( id_col = 2 id_row = id_row id_value = ls_dd04v-datatype ).
    go_excel->set_cell_data( id_col = 3 id_row = id_row id_value = ls_dd04v-leng ).
    IF ls_dd04v-decimals IS NOT INITIAL.
      go_excel->set_cell_data( id_col = 4 id_row = id_row id_value = ls_dd04v-decimals ).
    ENDIF.
    ed_match = 'X'.
  ELSE.
    READ TABLE gt_dd07v TRANSPORTING NO FIELDS WITH KEY domvalue_l = id_data
    BINARY SEARCH.
    IF sy-subrc = 0.
      ed_match = 'X'.
    ENDIF.
  ENDIF.

ENDFORM.                    "get_ddic_data_element_xls
*&---------------------------------------------------------------------*
*&      Form  write_sturc
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->IT_STRUC   text
*----------------------------------------------------------------------*
FORM write_sturc USING it_struc TYPE tt_func.
  DATA: ls_struc   TYPE ts_func,
        ld_tabname TYPE rmdi_name,
        lt_field   TYPE rmdi_tabfld_t,
        ls_field   TYPE rmdi_tabfld.
  CHECK it_struc IS NOT INITIAL.

  SORT it_struc BY structure.
  DELETE ADJACENT DUPLICATES FROM it_struc COMPARING structure.

  WRITE /(30) '数据结构定义'.
  SKIP 1.
  LOOP AT it_struc INTO ls_struc.
*   校验是否是表类型
    DATA: ls_dd40l TYPE dd40l.
    SELECT SINGLE * FROM dd40l INTO ls_dd40l
    WHERE   typename = ls_struc-structure.
    IF sy-subrc = 0.
      ld_tabname = ls_dd40l-rowtype.
    ELSE.
      ld_tabname = ls_struc-structure.
    ENDIF.

    FORMAT INTENSIFIED COLOR = 4.
    WRITE :/(30) ls_struc-structure.
    "获取描述
    DATA: ld_ddtext TYPE dd02t-ddtext.
    SELECT SINGLE ddtext FROM  dd02t INTO ld_ddtext
    WHERE tabname = ld_tabname.
    IF sy-subrc = 0.
      WRITE (40) ld_ddtext.
    ENDIF.
    FORMAT INTENSIFIED COLOR = 0.
*    WRITE sy-uline.

    CALL FUNCTION 'RM_TABLE_INFO_GET'
      EXPORTING
        i_tabname     = ld_tabname
*       I_FIELDNAME   =
*       I_LANGU       =
        i_read_texts  = 'X'
      IMPORTING
*       E_TABHEADER   =
*       E_TABFIELD_W  =
        e_tabfields_t = lt_field
      EXCEPTIONS
        not_found     = 1
        ddic_error    = 2
        OTHERS        = 3.
    IF sy-subrc = 0.
      LOOP AT lt_field INTO ls_field.
        WRITE: /(30) ls_field-fieldname ,
        (20) ls_field-datatype,
        (10) ls_field-leng.
        IF ls_field-decimals IS INITIAL.
          WRITE (10)  ''.
        ELSE.
          WRITE (10)  ls_field-decimals.
        ENDIF.
        WRITE : (40) ls_field-fieldtext.
      ENDLOOP.
    ENDIF.
    SKIP 2.
  ENDLOOP.

ENDFORM.                    "write_sturc


*&---------------------------------------------------------------------*
*&      Form  write_sturc_xls
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*      -->CD_ROW     text
*      -->IT_STRUC   text
*----------------------------------------------------------------------*
FORM write_sturc_xls USING cd_row TYPE i
                           it_struc TYPE tt_func.
  DATA: ls_struc   TYPE ts_func,
        ld_tabname TYPE rmdi_name,
        lt_field   TYPE rmdi_tabfld_t,
        ls_field   TYPE rmdi_tabfld.
  CHECK it_struc IS NOT INITIAL.

  SORT it_struc BY structure.
  DELETE ADJACENT DUPLICATES FROM it_struc COMPARING structure.

  cd_row = cd_row + 2.
  go_excel->set_cell_data( id_col = 1 id_row = cd_row id_value = '数据结构定义' ).
  go_excel->set_cell_format( id_col = 1 id_row = cd_row id_bold = 1  id_bg_color = 36 ).


  LOOP AT it_struc INTO ls_struc.
    cd_row = cd_row + 2.
*   校验是否是表类型
    DATA: ls_dd40l TYPE dd40l.
    SELECT SINGLE * FROM dd40l INTO ls_dd40l
    WHERE   typename = ls_struc-structure.
    IF sy-subrc = 0.
      ld_tabname = ls_dd40l-rowtype.
    ELSE.
      ld_tabname = ls_struc-structure.
    ENDIF.

    go_excel->set_cell_data( id_col = 1 id_row = cd_row id_value = ls_struc-structure ).
    go_excel->set_cell_format( id_col = 1 id_row = cd_row id_bold = 1 id_bg_color = 36 ).

    "获取描述
    DATA: ld_ddtext TYPE dd02t-ddtext.
    SELECT SINGLE ddtext FROM  dd02t INTO ld_ddtext
    WHERE tabname = ld_tabname.
    IF sy-subrc = 0.
      go_excel->set_cell_data( id_col = 5 id_row = cd_row id_value = ld_ddtext ).
    ENDIF.

    CALL FUNCTION 'RM_TABLE_INFO_GET'
      EXPORTING
        i_tabname     = ld_tabname
*       I_FIELDNAME   =
*       I_LANGU       =
        i_read_texts  = 'X'
      IMPORTING
*       E_TABHEADER   =
*       E_TABFIELD_W  =
        e_tabfields_t = lt_field
      EXCEPTIONS
        not_found     = 1
        ddic_error    = 2
        OTHERS        = 3.
    IF sy-subrc = 0.
      LOOP AT lt_field INTO ls_field.
        cd_row = cd_row + 1.

        go_excel->set_cell_data( id_col = 1 id_row = cd_row id_value = ls_field-fieldname ).
        go_excel->set_cell_data( id_col = 2 id_row = cd_row id_value = ls_field-datatype ).
        go_excel->set_cell_data( id_col = 3 id_row = cd_row id_value = ls_field-leng ).

        IF ls_field-decimals IS NOT INITIAL.
          go_excel->set_cell_data( id_col = 4 id_row = cd_row id_value = ls_field-decimals ).
        ENDIF.

        go_excel->set_cell_data( id_col = 5 id_row = cd_row id_value = ls_field-fieldtext ).
      ENDLOOP.
    ENDIF.
  ENDLOOP.

ENDFORM.                    "write_sturc_xls

*&---------------------------------------------------------------------*
*& 包含               YFUNC_EXCEL
*&---------------------------------------------------------------------*
*&---------------------------------------------------------------------*
*&  包含                YFUNC_EXCEL
*&---------------------------------------------------------------------*

*&---------------------------------------------------------------------*
*&  包括                YFUNC_EXCEL
*&---------------------------------------------------------------------*
*&---------------------------------------------------------------------*
*&  包含                ZUTIL_EXCEL_V2
*&  公用模块
*&  &! 多程序共用  谨慎修改
*& [MOD-01]      LUBIN        08.09.2016 15:08:34  取消自动回行 影响输出效率
*                                                  所有cell操作增加缓存选项
*                                                  1W个CELL操作 自动输出一次
*  [MOD-02]       lubin       08.12.2017 16:51:26  所有的OLE操作都参与缓存统计
*                                                  而不仅仅是MOD-01中的CELL操作
*&--------------------------------------------------------------- ------*

DEFINE m_action.
  md_action = md_action + 1.

IF md_action = 10000.
CALL METHOD cl_gui_cfw=>flush
EXCEPTIONS
        cntl_system_error = 1
        cntl_error        = 2.
CLEAR md_action.
ENDIF.
END-OF-DEFINITION.
*----------------------------------------------------------------------*
*       CLASS lcl_concatenator DEFINITION
*----------------------------------------------------------------------*
* 由于SAP版本问题 不支持&& 操作符 引入一个concatenator类
*----------------------------------------------------------------------*
CLASS lcl_concatenator DEFINITION.
  PUBLIC SECTION.
    METHODS:
      refresh,
      append IMPORTING id_value TYPE any,
      output IMPORTING id_sperator      TYPE any OPTIONAL
             RETURNING VALUE(rd_result) TYPE string.

  PRIVATE SECTION.
    DATA: ms_text TYPE string,
          mt_text TYPE TABLE OF string.
ENDCLASS.                    "lcl_concatenator DEFINITION


*----------------------------------------------------------------------*
*       CLASS lcl_concatenator IMPLEMENTATION
*----------------------------------------------------------------------*
*
*----------------------------------------------------------------------*
CLASS lcl_concatenator IMPLEMENTATION.
  METHOD refresh.
    CLEAR mt_text.
  ENDMETHOD.                    "refresh

  METHOD append.
    ms_text = id_value.
    CONDENSE ms_text.
    APPEND ms_text TO mt_text.
  ENDMETHOD.                    "append

  METHOD output.
    LOOP AT mt_text INTO ms_text.
      IF rd_result IS INITIAL.
        rd_result = ms_text.
      ELSE.
        CONCATENATE  rd_result id_sperator ms_text INTO rd_result .
      ENDIF.
    ENDLOOP.
  ENDMETHOD.                    "output
ENDCLASS.                    "lcl_concatenator IMPLEMENTATION


TYPE-POOLS:ole2.

*----------------------------------------------------------------------*
*       CLASS lcl_excel DEFINITION
*----------------------------------------------------------------------*
*
*----------------------------------------------------------------------*
CLASS lcl_excel DEFINITION.
  PUBLIC SECTION.
    METHODS:
      constructor     IMPORTING id_xlsfile  TYPE any OPTIONAL"excel文件 绝对路径
                                id_visiable TYPE n DEFAULT '0',"可见性: 0 不可见 1 可见
      get_ole_obj     IMPORTING id_obj_name TYPE any
                      EXPORTING eo_obj      TYPE ole2_object,
*<!--  sheet  -->
      select_sheet    IMPORTING   id_pos       TYPE i OPTIONAL ,"sheet number


      add_sheet       IMPORTING id_pos       TYPE i OPTIONAL
                                id_after     TYPE char1 OPTIONAL"X 位置在指定sheet之后 '
                                id_sheetname TYPE any OPTIONAL,

      rename_sheet    IMPORTING id_pos       TYPE i OPTIONAL
                                id_sheetname TYPE any OPTIONAL,

      copy_sheet      IMPORTING id_pos           TYPE i OPTIONAL
                                id_new_sheetname TYPE any OPTIONAL,

*<!--  cell  -->
      select_cell   IMPORTING id_row TYPE any
                              id_col TYPE any,

      set_cell_data IMPORTING id_row                  TYPE any OPTIONAL
                              id_col                  TYPE any OPTIONAL
                              id_value                TYPE any
                              id_just                 TYPE any OPTIONAL "对齐方式
*                              id_wrap   TYPE any DEFAULT  1
                              id_wrap                 TYPE any OPTIONAL

                              id_output_initial_value TYPE any DEFAULT '',


      set_cell_format IMPORTING id_row       TYPE any OPTIONAL
                                id_col       TYPE any OPTIONAL

                                id_just      TYPE any OPTIONAL "1:右 2:左 3:中心
                                id_wrap      TYPE any OPTIONAL "1:自动回行
                                id_font_name TYPE any OPTIONAL"字体名
                                id_bold      TYPE any OPTIONAL"1: 加粗
                                id_italic    TYPE any OPTIONAL"1: 斜体
                                id_color     TYPE any OPTIONAL"颜色
                                id_size      TYPE any OPTIONAL"字号
                                id_bg_color  TYPE any OPTIONAL,


*<!--  range  -->
      select_range IMPORTING id_start_row TYPE any OPTIONAL
                             id_start_col TYPE any OPTIONAL
                             id_end_row   TYPE any OPTIONAL
                             id_end_col   TYPE any OPTIONAL
                             id_range     TYPE any OPTIONAL"range (A1:A1)
                             id_num_2_en  TYPE char1 DEFAULT 'X', "是否进行数字到字母的转换

      set_range_format IMPORTING
                         id_just      TYPE any OPTIONAL
                         id_wrap      TYPE any OPTIONAL
                         id_font_name TYPE any OPTIONAL
                         id_bold      TYPE any OPTIONAL
                         id_italic    TYPE any OPTIONAL
                         id_color     TYPE any OPTIONAL
                         id_size      TYPE any OPTIONAL
                         id_bg_color  TYPE any OPTIONAL,

      "合并
      merge_range,

      "边框
      set_range_border IMPORTING id_all   TYPE any  DEFAULT 'X'
                                 id_left  TYPE any OPTIONAL
                                 id_right TYPE any OPTIONAL
                                 id_top   TYPE any OPTIONAL
                                 id_down  TYPE any OPTIONAL,
      "清空
      clear_range_data,

      "复制
      copy_range,
      paste_range,

*<!--  row  -->
      set_row_height IMPORTING id_row_no TYPE any
                               id_height TYPE any ,

      insert_rows   IMPORTING id_row_no    TYPE any
                              id_row_count TYPE i DEFAULT 1,
      frozen_window IMPORTING id_row_no TYPE any,


*<!--  column  -->
      set_col_width IMPORTING id_col_no TYPE any
                              id_width  TYPE any OPTIONAL,

*<!--  save & exit -->
      save IMPORTING id_open TYPE char1 DEFAULT 'X',
      terminate.

    METHODS:
      create_excel
        IMPORTING
          id_xlsfile TYPE any
          id_visible TYPE n,

*    CLASS-METHODS:
*     excel 列由数值->字母
      transform_num_to_en IMPORTING id_col_num       TYPE any
                          RETURNING VALUE(rd_col_en) TYPE char10,
*     产生range格式数据
      generate_range IMPORTING id_start_row    TYPE any
                               id_start_col    TYPE any
                               id_end_row      TYPE any
                               id_end_col      TYPE any
                     RETURNING VALUE(rd_range) TYPE char50.

    CLASS-DATA:
          md_en_sequence TYPE char26 VALUE 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'.

  PRIVATE SECTION.

    DATA:
      md_xlsfile       TYPE string,
      md_file_exist(1),
      md_cell_count    TYPE i.

    DATA: md_action TYPE i. "[MOD-02] 缓存的操作数

    DATA: mo_concatenator TYPE REF TO lcl_concatenator.

    DATA: excel    TYPE ole2_object,
          window   TYPE ole2_object,
          book     TYPE ole2_object,
          sheets   TYPE ole2_object,
          sheet    TYPE ole2_object,
          cell     TYPE ole2_object,
          row      TYPE ole2_object,
          col      TYPE ole2_object,
          range    TYPE ole2_object,
          borders  TYPE ole2_object,
          font     TYPE ole2_object,
          interior TYPE ole2_object.
ENDCLASS.                    "lcl_excel DEFINITION


*----------------------------------------------------------------------*
*       CLASS lcl_excel IMPLEMENTATION
*----------------------------------------------------------------------*
*
*----------------------------------------------------------------------*
CLASS lcl_excel IMPLEMENTATION.
  METHOD constructor.
    IF id_xlsfile IS NOT INITIAL.
      md_xlsfile = id_xlsfile.  "文件名赋给私有变量

      "-检查文件是否存在
      DATA: ld_fname TYPE string,
            ld_rst   TYPE c.
      ld_fname = md_xlsfile.
      md_file_exist = 'X'.
      CALL METHOD cl_gui_frontend_services=>file_exist
        EXPORTING
          file                 = ld_fname
        RECEIVING
          result               = ld_rst
        EXCEPTIONS
          cntl_error           = 1
          error_no_gui         = 2
          wrong_parameter      = 3
          not_supported_by_gui = 4
          OTHERS               = 5.
      IF sy-subrc <> 0 OR ld_rst NE 'X' .
        md_file_exist = space.       "文件不存在
      ENDIF.
    ENDIF.

    "新建或打开Excel文件
    CALL METHOD create_excel
      EXPORTING
        id_xlsfile = md_xlsfile
        id_visible = id_visiable.

    CREATE OBJECT mo_concatenator.
  ENDMETHOD.                    "constructor



  METHOD create_excel.
    CREATE OBJECT excel 'EXCEL.APPLICATION'.
    IF sy-subrc NE 0.
      MESSAGE 'EXCEL创建错误' TYPE 'S' DISPLAY LIKE 'E'.
      EXIT.
    ENDIF.
    SET PROPERTY OF excel 'VISIBLE' = id_visible.
    CALL METHOD OF
      excel
        'WORKBOOKS' = book.
    IF md_file_exist = 'X'.
      CALL METHOD OF
        book
        'OPEN'
        EXPORTING
          #1 = id_xlsfile.

      select_sheet(  ).

    ELSE.
      SET PROPERTY OF excel 'SheetsInNewWorkbook' = 1.
      CALL METHOD OF
        book
          'ADD' = sheet.
      CALL METHOD OF
        sheet
        'ACTIVATE'.
*      FREE OBJECT sheet.
    ENDIF.

  ENDMETHOD.                    "create_excel

  METHOD get_ole_obj.
    CASE id_obj_name.
      WHEN 'EXCEL'.
        eo_obj = excel.
      WHEN 'BOOK'.
        eo_obj = book.
      WHEN 'SHEETS'.
        eo_obj = sheets.
      WHEN 'SHEET'.
        eo_obj = sheet.
      WHEN 'CELL'.
        eo_obj = cell.
      WHEN 'ROW'.
        eo_obj = row.
      WHEN 'COL'.
        eo_obj = col.
      WHEN 'RANGE'.
        eo_obj = range.
    ENDCASE.
  ENDMETHOD.                    "get_ole_obj

  METHOD select_sheet.
    FREE OBJECT sheet.

    m_action.

    IF sheets IS INITIAL.
      GET PROPERTY OF excel 'ActiveWorkbook' = book.
      CALL METHOD OF
        book
          'WORKSHEETS' = sheets.

    ENDIF.

    IF id_pos IS NOT INITIAL.

      CALL METHOD OF
              sheets
      'Item' = sheet
      EXPORTING
              #1 = id_pos.

      CALL METHOD OF
        sheet
        'ACTIVATE'.
    ELSE.
      CALL METHOD OF
        excel
          'ActiveSheet' = sheet.
    ENDIF.
  ENDMETHOD.                    "select_sheet

  METHOD add_sheet.
    DATA: lo_sheet_pointed TYPE ole2_object,
          lo_sheet_add     TYPE ole2_object.


    select_sheet( id_pos ).

    lo_sheet_pointed = sheet.

    CALL METHOD OF
          sheets
    'Add' = lo_sheet_add
    EXPORTING
          #1 = lo_sheet_pointed.

    IF id_sheetname IS NOT INITIAL.
      SET PROPERTY OF lo_sheet_add 'NAME' = id_sheetname NO FLUSH.
      m_action.
    ENDIF.

    IF id_after = 'X'.
      CALL METHOD OF
        lo_sheet_pointed
        'MOVE'
        NO FLUSH
        EXPORTING
          #1 = lo_sheet_add.
      m_action.
    ENDIF.

    CALL METHOD OF
      lo_sheet_add
      'ACTIVATE' NO FLUSH.
    m_action.

    FREE OBJECT lo_sheet_pointed NO FLUSH.
    m_action.

    sheet    = lo_sheet_add.

  ENDMETHOD.                    "add_sheet


  METHOD rename_sheet.

    select_sheet( id_pos ).

    SET PROPERTY OF sheet 'NAME' = id_sheetname NO FLUSH.
    m_action.

  ENDMETHOD.                    "rename_sheet

  METHOD copy_sheet.


  ENDMETHOD.                    "copy_sheet


  METHOD select_cell .
    CHECK id_row IS NOT INITIAL AND
              id_col IS NOT INITIAL.


    IF cell IS NOT INITIAL.
*     处理新的cell之前 先释放旧的cell的句柄
      FREE OBJECT cell NO FLUSH.
      m_action.
    ENDIF.

    CALL METHOD OF
          excel
    'Cells' = cell
    NO
          FLUSH
    EXPORTING
          #1 = id_row
          #2 = id_col.
    m_action.

  ENDMETHOD.                    "select_cell

  METHOD set_cell_data.
    IF id_output_initial_value = ''.
*     是否输出初始值
      CHECK id_value IS NOT INITIAL.
    ENDIF.

    select_cell( id_row = id_row id_col = id_col ).

    SET PROPERTY OF cell 'value' = id_value NO FLUSH.
    m_action.

    IF id_just IS NOT INITIAL.
      SET PROPERTY OF cell 'HorizontalAlignment' = id_just NO FLUSH.
      m_action.
    ENDIF.

    IF id_wrap IS NOT INITIAL.
      SET PROPERTY OF cell 'WrapText' = id_wrap NO FLUSH."设置自动换行 如果在模板中已经设置了自动换行 则该属性不起效
      m_action.
    ENDIF.

    m_action.

    "[MOD-01]  "[MOD-02]
***    md_cell_count = md_cell_count + 1.
***    IF md_cell_count = 10000.
***      CALL METHOD cl_gui_cfw=>flush
***        EXCEPTIONS
***          cntl_system_error = 1
***          cntl_error        = 2.
***      CLEAR md_cell_count.
***    ENDIF.
  ENDMETHOD.                    "set_cell_data

  METHOD set_cell_format.
    select_cell( id_row = id_row id_col = id_col ).

    IF id_just IS NOT INITIAL.
      SET PROPERTY OF cell 'HORIZONTALALIGNMENT' = id_just NO FLUSH.
      m_action.
    ENDIF.

    IF id_wrap IS NOT INITIAL.
      SET PROPERTY OF cell 'WrapText' = id_wrap NO FLUSH.
      m_action.
    ENDIF.

    CALL METHOD OF
      cell
        'FONT' = font
                 NO
                 FLUSH.
    m_action.


    IF id_bold IS NOT INITIAL.
      SET PROPERTY OF font 'BOLD' = id_bold NO FLUSH.
      m_action.
    ENDIF.
    IF id_italic IS NOT INITIAL.
      SET PROPERTY OF font 'Italic' = id_italic NO FLUSH.
      m_action.
    ENDIF.

    IF id_size IS NOT INITIAL.
      SET PROPERTY OF font 'SIZE' = id_size NO FLUSH.
      m_action.
    ENDIF.

    IF id_font_name IS NOT  INITIAL.
      SET PROPERTY OF font 'NAME' = id_font_name NO FLUSH.
      m_action.
    ENDIF.

    IF id_color IS NOT INITIAL.
      SET PROPERTY OF font 'COLORINDEX' = id_color NO FLUSH.
      m_action.
    ENDIF.
    FREE OBJECT font NO FLUSH.
    m_action.

    IF id_bg_color IS NOT INITIAL.
      CALL METHOD OF
        cell
          'Interior' = interior
                       NO FLUSH.
      m_action.

      SET PROPERTY OF interior 'COLORINDEX' = id_bg_color NO FLUSH.
      m_action.
      FREE OBJECT interior NO FLUSH.
      m_action.
    ENDIF.


  ENDMETHOD.                    "set_cell_format


  METHOD select_range.
    DATA: ld_range TYPE string.
    IF id_range IS NOT INITIAL.
      ld_range = id_range.
    ELSE.

      IF id_num_2_en = 'X'.
        ld_range = generate_range(
                      id_start_row = id_start_row
                      id_start_col = id_start_col
                      id_end_row = id_end_row
                      id_end_col = id_end_col ).
      ELSE.
*        ld_range = id_start_col && id_start_row && ':' &&
*                   id_end_col && id_end_row .

        mo_concatenator->refresh( ).
        mo_concatenator->append( id_start_col ).
        mo_concatenator->append( id_start_row ).
        mo_concatenator->append( ':' ).
        mo_concatenator->append( id_end_col ).
        mo_concatenator->append( id_end_row ).
        ld_range = mo_concatenator->output( ).
      ENDIF.
    ENDIF.


    IF range IS NOT INITIAL.
      FREE OBJECT range NO FLUSH.
      m_action.
    ENDIF.

    CALL METHOD OF
          excel
    'RANGE' = range
    NO FLUSH
    EXPORTING
          #1 = ld_range .
    m_action.

  ENDMETHOD.                    "select_range

  METHOD set_range_format .

    IF id_just IS NOT INITIAL.
      SET PROPERTY OF range 'HORIZONTALALIGNMENT' = id_just NO FLUSH.
      m_action.
    ENDIF.

    IF id_wrap IS NOT INITIAL.
      SET PROPERTY OF range 'WrapText' = id_wrap NO FLUSH.
      m_action.
    ENDIF.

    CALL METHOD OF
      range
        'FONT' = font NO FLUSH.
    m_action.


    IF id_bold IS NOT INITIAL.
      SET PROPERTY OF font 'BOLD' = id_bold NO FLUSH.
      m_action.
    ENDIF.
    IF id_italic IS NOT INITIAL.
      SET PROPERTY OF font 'Italic' = id_italic NO FLUSH.
      m_action.
    ENDIF.

    IF id_size IS NOT INITIAL.
      SET PROPERTY OF font 'SIZE' = id_size NO FLUSH.
      m_action.
    ENDIF.

    IF id_font_name IS NOT  INITIAL.
      SET PROPERTY OF font 'NAME' = id_font_name NO FLUSH.
      m_action.
    ENDIF.

    IF id_color IS NOT INITIAL.
      SET PROPERTY OF font 'COLORINDEX' = id_color NO FLUSH.
      m_action.
    ENDIF.
    FREE OBJECT font NO FLUSH.


    IF id_bg_color IS NOT INITIAL.
      CALL METHOD OF
        range
          'Interior' = interior
                       NO FLUSH.
      m_action.

      SET PROPERTY OF interior 'COLORINDEX' = id_bg_color NO FLUSH.
      m_action.
      FREE OBJECT interior NO FLUSH.
      m_action.
    ENDIF.

  ENDMETHOD.                    "set_range_format

  METHOD merge_range.
    SET PROPERTY OF range 'Merge' = 1 NO FLUSH.
    m_action.

  ENDMETHOD.                    "merge_range


  METHOD set_range_border.
    DATA:ld_line_no TYPE n.

    IF id_all = 'X'.
      CALL METHOD OF
        range
          'BORDERS' = borders NO FLUSH.
      m_action.
    ELSE.
      CASE 'X'.
        WHEN id_left.
          ld_line_no = 1.
        WHEN id_right.
          ld_line_no = 2.
        WHEN id_top.
          ld_line_no = 3.
        WHEN id_down.
          ld_line_no = 4.
      ENDCASE..

      CALL METHOD OF
              range
      'BORDERS' = borders
      NO FLUSH
      EXPORTING
              #1 = ld_line_no.
      m_action.
    ENDIF.

    SET PROPERTY OF borders 'LINESTYLE' = 1 NO FLUSH.
    m_action.

    SET PROPERTY OF borders 'WEIGHT' = 2 NO FLUSH.
    m_action.

    FREE OBJECT borders NO FLUSH.
  ENDMETHOD.                    "set_range_border

  METHOD clear_range_data.
    CALL METHOD OF
      range
      'ClearContents' NO FLUSH.
    m_action.
  ENDMETHOD.                    "clear_range_data

  METHOD copy_range.
    CALL METHOD OF
      range
      'copy' NO FLUSH.
    m_action.
  ENDMETHOD.                    "copy_range

  METHOD paste_range.
    CALL METHOD OF
      range
      'PasteSpecial' NO FLUSH.
    m_action.
  ENDMETHOD.                    "paste_range

  METHOD set_row_height.
    CALL METHOD OF
          excel
    'ROWS' = row
    NO FLUSH
    EXPORTING
          #1 = id_row_no.
    m_action.
    SET PROPERTY OF row  'RowHeight' = id_height NO FLUSH.
    m_action.

    FREE OBJECT row NO FLUSH.
    m_action.

  ENDMETHOD.                    "set_row_height

  METHOD insert_rows.
    CALL METHOD OF
          excel
    'ROWS' = row
    NO FLUSH
    EXPORTING
          #1 = id_row_no.
    m_action.

    DO id_row_count TIMES.
      CALL METHOD OF
        row
        'INSERT' NO FLUSH.
      m_action.

    ENDDO.

    FREE OBJECT row NO FLUSH.
    m_action.
  ENDMETHOD.                    "insert_rows

  METHOD frozen_window.
    CALL METHOD OF
          excel
    'ROWS' = row
    NO FLUSH
    EXPORTING
          #1 = id_row_no.

    CALL METHOD OF
      row
      'SELECT'
      NO FLUSH.

    m_action.

    CALL METHOD OF
      excel
        'ActiveWindow' = window
                         NO FLUSH.

    SET PROPERTY OF  window 'FreezePanes' = 'True' NO FLUSH.
    m_action.

    FREE OBJECT row NO FLUSH.
    FREE OBJECT window NO FLUSH.
    m_action.
  ENDMETHOD.                    "frozen_window

  METHOD set_col_width.
    CALL METHOD OF
          excel
    'COLUMNS' = col NO FLUSH
    EXPORTING
          #1 = id_col_no.
    m_action.
    IF id_width IS INITIAL.
      CALL METHOD OF
        col
        'AutoFit' NO FLUSH.
      m_action.
    ELSE.
      SET PROPERTY OF col  'columnwidth' = id_width NO FLUSH.
      m_action.
    ENDIF.
    FREE OBJECT col NO FLUSH.
    m_action.
  ENDMETHOD.                    "set_colwidth


  METHOD save.
    GET PROPERTY OF excel 'ActiveWorkbook' = book.
    SET PROPERTY OF excel 'DisplayAlerts' = 0.

    IF md_file_exist = 'X'.
      "打开已有文件情况下
      CALL METHOD OF
        book
        'SAVE'.
    ELSE.
      "新建文件情况下
      CALL METHOD OF
        book
        'SAVEAS'
        EXPORTING
          #1 = md_xlsfile  "文件完整路径
          #2 = 1. "0:不覆盖不提示,进程不结束 1:提示,若是则进程结束
    ENDIF.

    CALL METHOD OF
      book
      'CLOSE'.
    CALL METHOD OF
      excel
      'QUIT'.
    FREE OBJECT: excel, book, sheet.


* 自动打开导出文件
    IF id_open = 'X'.
      CALL METHOD cl_gui_frontend_services=>execute
        EXPORTING
          document               = md_xlsfile
*         application            =
*         parameter              =
*         default_directory      =
*         maximized              =
*         minimized              =
*         synchronous            =
*         operation              = 'OPEN'
        EXCEPTIONS
          cntl_error             = 1
          error_no_gui           = 2
          bad_parameter          = 3
          file_not_found         = 4
          path_not_found         = 5
          file_extension_unknown = 6
          error_execute_failed   = 7
          synchronous_failed     = 8
          not_supported_by_gui   = 9
          OTHERS                 = 10.
    ENDIF.

  ENDMETHOD.                    "save_excel

  METHOD terminate.
*   适用于用代码自动填充一个模板后
*   一个未保存的excel的场景

*   excel可见
    SET PROPERTY OF excel 'VISIBLE' = 1.

*   清空相关句柄
    FREE OBJECT: excel, book, sheet.
  ENDMETHOD.                    "terminate

  METHOD transform_num_to_en.
    DATA: ld_offset   TYPE i,
          ld_quotient TYPE i,
          ld_input    TYPE i.
    ld_input = id_col_num.
*   余数
    ld_offset = ld_input MOD 26.
*   商数
    ld_quotient = ( ld_input - ld_offset ) / 26.
    IF ld_quotient > 0.
*     商数 > 0 递归
*      rd_col_en = rd_col_en && transform_num_to_en( ld_quotient ).

      mo_concatenator->refresh( ).
      mo_concatenator->append( rd_col_en ).
      DATA: ld_en TYPE string.
      ld_en = transform_num_to_en( ld_quotient ).
      mo_concatenator->append( ld_en ).
      rd_col_en = mo_concatenator->output( ).

    ENDIF.

    ld_offset = ld_offset - 1.

*    rd_col_en = rd_col_en && md_en_sequence+ld_offset(1).

    mo_concatenator->refresh( ).
    mo_concatenator->append( rd_col_en ).
    mo_concatenator->append( md_en_sequence+ld_offset(1) ).
    rd_col_en = mo_concatenator->output( ).
  ENDMETHOD.                    "transform_num_to_en

  METHOD generate_range.
*    rd_range = transform_num_to_en( id_start_col ) &&
*               id_start_row && ':' &&
*               transform_num_to_en( id_end_col ) &&
*               id_end_row.

    mo_concatenator->refresh( ).
    DATA: ld_col TYPE string.
    ld_col = transform_num_to_en( id_start_col ).
    mo_concatenator->append( ld_col ).
    mo_concatenator->append( id_start_row  ).
    mo_concatenator->append( ':'  ).

    ld_col = transform_num_to_en( id_end_col ).
    mo_concatenator->append( ld_col ).
    mo_concatenator->append( id_end_row ).
    rd_range = mo_concatenator->output( ).

  ENDMETHOD.                    "generate_range

ENDCLASS.                    "lcl_excel IMPLEMENTATION

 

标签:ld,excel,接口,col,ABAP,文档,TYPE,id,row
From: https://www.cnblogs.com/ap-ad-java-abap/p/17965261

相关文章

  • 自定义注解实现接口入参字段校验
    使用的类javax.validation导入的包<dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-validation</artifactId><version>xxxx.RELEASE</version></dependency>通过springb......
  • java Flink 校验接口数据
    要使用Java编写Flink程序来校验接口的数据,可以按照以下步骤进行操作。首先,需要引入相关依赖包。在pom.xml文件中添加如下依赖项:org.apache.flinkflink-streaming-java_2.12{FLINK版本号}其中{FLINK版本号}应该被替换为所使用的Flink版本号。创建一个新的Java类,并导入必要......
  • mvc5接口报错:The JSON request was too large to be deserialized的一种原因
    是mvc5版本的接口,接口使用了dynamic接收数组,json对象数组只有56个,length长度不到10万,但是提交就报TheJSONrequestwastoolargetobedeserialized这个错。在.netcore中,dynamic是不需要前端把字段用stringfy序列化为字符串的就能处理的。但是mvc5如果不在前端把dynamic接收......
  • 软件测试(功能、接口、性能、自动化)详解
    软件测试(功能、接口、性能、自动化)详解前言:软件测试是软件开发过程中不可或缺的重要环节,它用于验证软件的质量、可靠性和性能是否符合预期。软件测试涵盖了多个方面,包括功能测试、接口测试、性能测试和自动化测试。一、软件测试功能测试测试用例编写是软件测试的基本技能;也......
  • [源码分析] - flex 标准文档导读与 一个rust实现解析
    本文是w3中css-flexbox[标准文档](CSSFlexibleBoxLayoutModuleLevel1(w3.org)解读.(2023.1),并对一些开源实现进行调研分析.文档导读csslayoutmodecsslayout模式用于确定在盒模型中的元素如何排布(大小与位置),在css2.1中有如下几种方式.blocklayout,块级别......
  • markdown文档的一些特殊用法
    markdown中使用表情符号从表情符号Unicode列表获取到一个表情的Unicode编码,如......
  • 基于SpringBoot+Vue的OA办公系统设计实现(源码+lw+部署文档+讲解等)
    (文章目录)前言:heartpulse:博主介绍:✌全网粉丝10W+,CSDN特邀作者、博客专家、CSDN新星计划导师、全栈领域优质创作者,博客之星、掘金/华为云/阿里云/InfoQ等平台优质作者、专注于Java、小程序技术领域和毕业项目实战✌:heartpulse:......
  • Text Intelligence - TextIn.com AI时代下的智能文档识别、处理、转换
    一、智能文档处理介绍在AI时代,智能文档处理技术正变得越来越重要。它包括了智能文字识别(OCR)、智能文档信息抽取、文档图像处理以及文档转换等多个方面。这些技术共同构成了现代信息处理的核心,广泛应用于数据分析、自动化办公、数字化存档以及更多其他领域。智能文字识别(OCR)智......
  • 博客后台接口分页优化-访问记录篇
    博客后台接口优化-访问记录......
  • 接口的定义和实现
    概念普通类:只有具体实现抽象类:具体实现和规范(抽象方法)都有!接口:只有规范!自己无法写方法,专业的约束!约束和实现分离:面向接口编程。接口就是规范,定义的是一组规则,体现了现实世界中“如果你是…则必须能…”的思想。如果你是天使,则必须能飞。如果你是汽车,则必须能跑。如果你是好人,......