1. ABAP2XLSX手动创建一个Excel表、合并单元格、设置单元格格式并输出,参考标准演示文档ZDEMO_EXCEL1
-
代码:
DATA: lo_excel TYPE REF TO zcl_excel, lo_worksheet TYPE REF TO zcl_excel_worksheet, lo_hyperlink TYPE REF TO zcl_excel_hyperlink, column_dimension TYPE REF TO zcl_excel_worksheet_columndime, lo_style_bold_border TYPE REF TO zcl_excel_style. CONSTANTS: gc_save_file_name TYPE string VALUE 'zdemo_excel1.xlsx'. "文件名 CONSTANTS: lc_typekind_string TYPE abap_typekind VALUE cl_abap_typedescr=>typekind_string. "获取单元格类型 INCLUDE zdemo_excel_outputopt_incl. START-OF-SELECTION. CREATE OBJECT lo_excel. "创建活动的Excel对象 lo_worksheet = lo_excel->get_active_worksheet( ). "获取活动的Excel对象 lo_worksheet->set_title( ip_title = 'Sheet1' ). "设置sheet Name lo_worksheet->set_cell( ip_column = '