通过事务码-ZXLWB_WORKBENCH启动Workbench,输入名称并创建一个Form
点击保存按钮以保存当前Form
点击Name of the context将CL_SALV_TREE 分配给context
选择Auto
选择一个范围,点击Area in the template
成功之后可以看到模板的范围已经设定好
最后点击激活按钮
复制DEMO程序SALV_DEMO_TREE_SIMPLE
做如下修改:
双击100屏幕的状态,添加EXCEL 的button
在USER_COMMAND中添加ZXLWB_CALLFORM函数
FORM D0100_PAI .
CASE OK_CODE.
WHEN 'BACK' OR 'EXIT' OR 'QUIT'.
CLEAR OK_CODE.
SET SCREEN 0.
LEAVE SCREEN.
WHEN 'EXCEL'.
CALL FUNCTION 'ZXLWB_CALLFORM'
EXPORTING
IV_FORMNAME = 'YN_XLSX_TREE_TEST'
IV_CONTEXT_REF = GR_TREE
EXCEPTIONS
PROCESS_TERMINATED = 1
OTHERS = 2.
ENDCASE.
ENDFORM.
最后测试一下