Create and save a new form

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

Assign a context to the form 

Assign a context SDBXXLTABS_TAB to the form. When an automatically creation of the Form structure will be prompted, you should press the button

to create a structure manually.

Context binding for components

Perform Context binding for «Loopstep» , «Value» and «Grid» according to scheme below:

Markup of template

Markup an Excel-template and perform template binding as shown below :

Setup data validation option for cell A1

• Put cursor into the A1 cell.

• Choose Data Validation from the Data Tools group on the Data tab.

• Pick 'List' value from listbox Allow on the on the Settings tab

• Put some text (no matter, it will be replaced in runtime) into field Source on the Settings tab 

• Optionally, specify error text on the Error Allert tab (if needed)

Setup component VALUE in the form structure tree.

• Follow to the properties tab for component INPUT_FIELD and select 'From Dataset' option in the 'Data validation' item

• In popup window select Grid component and its column in order to specify values for dropdown of the cell  

Activate the Form by pressing a button