This article explains about creating dependent dropdown list for whole column in Excel using XlsIO.
What is data validation?
Data validation is a feature of Excel that helps to control the kind of information that is entered in a worksheet.
List type data validation allows creating a drop-down list with the actual data that has to be selected in the preferred cell. Users can quickly select an item from the list and then move on to the next entry without typing unwanted data.
Indirect function is used for creating data validation list that depends on the value from another cell.
How indirect function works?
Indirect function returns the reference specified by a text string. References are immediately evaluated to display their contents. INDIRECT is used when the reference to a cell within a formula needs to be changed without changing the formula itself.
Code snippet for creating dependent dropdown list for whole column in Excel using XlsIO
The following C#/VB complete code snippet shows the creation of dependent data validation for entire column in Excel using XlsIO.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|