How to set data validation for numbers?
Use the following code snippets to set data validation for numbers.
C#
// Data Validation for NumbersIDataValidation validation1 = sheet.Range["A3"].DataValidation; sheet.Range["A3"].Text = "Enter a Number"; validation1.AllowType = ExcelDataType.Integer; validation1.CompareOperator = ExcelDataValidationComparisonOperator.Between; validation1.FirstFormula = "0"; validation1.SecondFormula = "10"; validation1.ShowErrorBox = true; validation1.ErrorBoxText = "Enter Value between 0 to 10"; validation1.ErrorBoxTitle = "ERROR"; validation1.PromptBoxText = "Data Validation using Condition for Numbers"; validation1.ShowPromptBox = true;
|
VB
'Data Validation for Numbers Dim validation1 As IDataValidation = sheet.Range("A3").DataValidation sheet.Range("A3").Text = "Enter a Number" validation1.AllowType = ExcelDataType.Integer validation1.CompareOperator = ExcelDataValidationComparisonOperator.Between validation1.FirstFormula = "0" validation1.SecondFormula = "10" validation1.ShowErrorBox = True validation1.ErrorBoxText = "Enter Value between 0 to 10" validation1.ErrorBoxTitle = "ERROR" validation1.PromptBoxText = "Data Validation using Condition for Numbers" validation1.ShowPromptBox = True