Document Solutions for Excel, .NET Edition | Document Solutions
Features / Data Validations / Delete Validation
In This Topic
    Delete Validation
    In This Topic

    You can delete the applied validation rule using the Delete method of the IValidation interface.

    Refer to the following example code to know how you can delete validation rule applied to a cell or a range of cells in a worksheet.

    C#
    Copy Code 
    //Add validation
worksheet.Range["A1:A3"].Validation.Add(ValidationType.Whole, ValidationAlertStyle.Stop, ValidationOperator.Between, 1, 8);
worksheet.Range["B1:B3"].Validation.Add(ValidationType.Whole, ValidationAlertStyle.Stop, ValidationOperator.Between, 11, 18);

//Delete validation.
worksheet.Range["A1:A2"].Validation.Delete();