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. Image for the cookie policy date
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.





2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

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

Live Chat Icon For mobile