..2 Form
Create and save a new form
Launch XLSX Workbench, and in the popup window specify a form name HELLO_WORLD,
and then press the button Create
The workbench screen will be displayed:
Press a button
in the application toolbar, for the new form saving.
In the popup window specify a target package:
Assign a context to the form
To do it, press the button «Pencil» in a left-bottom frame, in the item «Name of the context»:
In the popup window specify LVC_S_TABL :
Next, you will be prompted to create a form structure automatically (based on context) :
You should press the button .
As result, «Pattern» and «Value» :
will be added under the «Sheet» in the form structure tree :
Added components are already assigned to the Context (i.e. will already have Context binding), but they're still need a Template binding.
We'll perform Template binding later, but first we perform markup of template.
Markup of template
Draw a gray colored rectangle in the Excel-template: just set a background color of cell range as shown in the picture below:
Assign «Pattern» to a target cell range in the Excel-template
Perform Template binding for a Pattern
according to scheme below:
Assign «Value» to a target cell in the Excel-template
Perform Template binding for Value
according to scheme below:
Activate the Form by pressing a button
Form is ready to use now.
Explanations
Summary Template/Context binding scheme: