SAP ABAP2XLSX EXCEL公式的使用之ZDEMO_EXCEL6
ABAP2XLSX Excel公式、单元格求和 ZDEMO_EXCEL6
代码:
DATA: lo_excel TYPE REF TO zcl_excel,
lo_worksheet TYPE REF TO zcl_excel_worksheet,
lv_row TYPE syindex,
lv_formula TYPE string.
CONSTANTS: gc_save_file_name TYPE string VALUE 'zdemo_excel.xlsx'.
INCLUDE zdemo_excel_outputopt_incl.
START-OF-SELECTION.
CREATE OBJECT lo_excel.
" Get active sheet
lo_worksheet = lo_excel->get_active_worksheet( ).
lo_worksheet->set_cell( ip_row = 4 ip_column = 'C' ip_value = 100 ).
lo_worksheet->set_cell( ip_row = 5 ip_column = 'C' ip_value = 1000 ).
lo_worksheet->set_cell( ip_row = 6 ip_column = 'C' ip_value = 150 ).
lo_worksheet->set_cell( ip_row = 7 ip_column = 'C' ip_value = -10 ).
lo_worksheet->set_cell( ip_row = 8 ip_column = 'C' ip_value = 500 ).
lo_worksheet->set_cell( ip_row = 9 ip_column = 'C' ip_formula = 'SUM(C4:C8)' ). "求和
lcl_output=>output( lo_excel ).
运行程序后,输出选项:
- Save to Frontend 前台输出,下载到电脑
- Save to Backend 后台输出
- Direct Display 直接输出,在SAP GUI显示Excel表
- Send Via Email 发送至邮箱
直接输出-前台显示结果:
post SAP-Garson
原文链接:https://blog.csdn.net/qq_30797051/article/details/108964251文章来自于网络,如果侵犯了您的权益,请联系站长删除!