We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to create a dependent dropdown list for whole column in Excel using XlsIO?

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

 

Download Complete Sample

The following C#/VB complete code snippet shows the creation of dependent data validation for entire column in Excel using XlsIO.

C#

 

VB

 

Article ID: Published Date: Last Revised Date: Platform: Control:
8367 01/31/2018 02/15/2018 WinForms XlsIO
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon