..2 Form

The Form's source is here .

How to import Form into the system see here . 


ALV Tree Excel SAP ABAP

Create and save a new form

Launch an XLSX Workbench, and create a new form with name ORGUNIT_HIERARCHY .


Assign a context to the form


Assign a context CL_SALV_TREE 
to the form

When an automatically creation of the Form structure will be prompted, you should press the button   to create a structure manually.


Markup of template

Markup an Excel-template as shown below :

 

Go to Excel menu: Data > Outline and uncheck the checkboxes in the popup-window (if they are set):


Create a Form structure

Add the component «Tree» under the component «Sheet»:



Template binding

Assign component «Tree» to the marked-up area of Excel-template :



Context binding

Assign component «Tree» to the context root node :



Activate the Form by pressing a button 

Form is ready to use.


Explanations

This example explains that, it is enough a single component «Tree» to insert an CL_SALV_TREE into the Printing form.  
You only need to assign «Tree» to the the template area and assign «Tree» to the CL_SALV_TREE of context.
  

There are many formatting options available in the Properties tab for the «Tree» component :