SAP 下载SMW0模板文件并附加数据导入到Excel示例

VIP文章 rogerix4

已于 2023-03-24 07:00:31 修改

阅读量947

点赞数

分类专栏： ABAP 实用程序记录 ABAP开发文章标签：前端 javascript python

于 2022-08-15 22:58:48 首次发布

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

版权

1. 效果

下载模板后，导入内表数据到Excel

2.代码

关键代码

DATA: excel     TYPE ole2_object, " Excel object
      worksheet TYPE ole2_object,
      workbooks TYPE ole2_object,   " Workbooks object
      workbook  TYPE ole2_object,
      sheet     TYPE ole2_object,   " Worksheet object
      cell      TYPE ole2_object,   " Cell object
      range     TYPE ole2_object.

  DATA: ls_mime        TYPE w3mime,
        lt_mime        TYPE TABLE OF w3mime,
        l_fullpath     TYPE string,
        l_path         TYPE string,
        l_filename     TYPE string,
        l_default_name TYPE string,
        l_filter       TYPE string,
        ls_key         TYPE wwwdatatab,
        l_objid        TYPE wwwdata-objid.

  DATA: xlsx_handling    TYPE REF TO cl_ehfnd_xlsx,
        xlsx_document    TYPE REF TO if_ehfnd_xlsx_doc,
        xlsx_sheets      TYPE cl_ehfnd_xlsx=>gty_th_sheet_info,
        first_xlsx_sheet TYPE REF TO if_ehfnd_xlsx_sheet.

  DATA: lv_xstring    TYPE xstring,
        l_field_count TYPE i,
        l_line        TYPE i,
        filesize      TYPE i.

  DATA: pt_xtab TYPE cpt_x255.

  FIELD-SYMBOLS:<fs_excel> TYPE any,
                <fs_field> TYPE any.
                
  l_objid =