SAP ABAP2XLSX输出内表到EXCEL表之ZDEMO_EXCEL3

VIP文章 rogerix4

已于 2023-03-24 07:55:52 修改

阅读量1.1k

点赞数 1

分类专栏： ABAP开发 ABAP2XLSX 文章标签： sap abap

于 2020-10-08 14:34:39 首次发布

本文链接：https://blog.csdn.net/qq_30797051/article/details/108962997

版权

1. ABAP2XLSX输出内表数据到Excel、新建Sheet、设置数据有效性验证、输出Range，参考标准演示文档ZDEMO_EXCEL3

代码：

TYPE-POOLS: abap.

DATA: lo_excel                TYPE REF TO zcl_excel,
      lo_worksheet            TYPE REF TO zcl_excel_worksheet,
      column_dimension        TYPE REF TO zcl_excel_worksheet_columndime.

DATA: ls_table_settings       TYPE zexcel_s_table_settings.


DATA: lv_title TYPE zexcel_sheet_title,
      lt_carr  TYPE TABLE OF scarr,
      lv_row TYPE zexcel_cell_row VALUE 2,
      lo_range TYPE REF TO zcl_excel_range.
DATA: lo_data_validation  TYPE REF TO zcl_excel_data_validation.
DATA: lt_test TYPE TABLE OF sflight.

FIELD-SYMBOLS: <carr> LIKE LINE OF lt_carr.

CONSTANTS: c_airlines TYPE string VALUE 'Airlines'.
CONSTANTS: gc_save_file_name TYPE string VALUE 'zdemo_excel3.xlsx'.


INCLUDE zdemo_excel_outputopt_incl.

PARAMETERS: p_empty TYPE flag.    "设置是否清空内表内容

START-OF-SELECTION.
  " Creates active sheet
  CREATE OBJECT lo_excel.

*第一张Sheet输出
  lo_worksheet = lo_excel->get_active_worksheet( ).
  lo_worksheet->set_title( ip_title