Category / Section
How to set Data validation for List?
1 min read
DataValidation is a feature in MS Excel which, makes it possible to dynamically validate data that is entered in a cell. The validation rules are specified in the Data Validation settings. XlsIO has support for writing data validation rules in a cell. Use the following code snippets to set data validation for list.
C#
//Data validation to list the values in the first cell
IDataValidation validation = sheet.Range["A1"].DataValidation;
sheet.Range["A1"].Text = "Data validation list";
validation.ListOfValues = new string[] { "ListItem1", "ListItem2", "ListItem3" };
validation.PromptBoxText = "Data Validation list";
validation.IsPromptBoxVisible = true;
validation.ShowPromptBox = true;
VB
'Data validation to list the values in the first cell
Dim validation As IDataValidation = sheet.Range("A1").DataValidation
sheet.Range("A1").Text = "Data validation list"
validation.ListOfValues = New String() {"ListItem1", "ListItem2", "ListItem3"}
validation.PromptBoxText = "Data Validation list"
validation.IsPromptBoxVisible = True
validation.ShowPromptBox = True
