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 =
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)