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: November 16, 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?

Platform: WinForms |
Control: XlsIO |
Published Date: January 31, 2018 |
Last Revised Date: February 15, 2018

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

 

ADD COMMENT
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.

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