call method of
      r_oth_g_sheet
      'SAVEAS'
    exporting
      #1            r_oth_l_destination
      #2            1
      #3            zpassw."增加密码设置 20200327 


附加删除文件,EXCEL编辑操作另存一个文件才不会占用
form delete_data_file using value(pv_filename).

  datalv_fname type string,
        lv_rc type i.

  lv_fname pv_filename.

* delete the file
  call method cl_gui_frontend_services=>file_delete
    exporting
      filename lv_fname
    changing
      rc       lv_rc
    exceptions
      others   0.

* flush to execute the deletion
  call method cl_gui_cfw=>flush.

endform.                    " DELETE_DAT_FILE
08-29 13:21