Concept

EasyXLS™ library allows you to create drop down lists in Excel file. A drop down list is a data validation that permits entering only values from the list in the cell.

Concept in action

The below example shows how to export an Excel file with a drop down list with valid values from a named range.