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