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 set data validation for numbers?

Platform: WinForms |
Control: XlsIO |
Published Date: April 30, 2011 |
Last Revised Date: July 18, 2014

Use the following code snippets to set data validation for numbers.


// 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;




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.

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