GcExcel .NET Overview
Key Features
Getting Started
Features
- Worksheet
- Workbook
- Comments
- Hyperlinks
- Sort
- Filter
- Group
- Conditional Formatting
- Data Validations
  - Add Validations
  - Delete Validation
  - Modify Validation
- Data Binding
- Digital Signatures
- Formulas
- Custom Functions
- Shapes and Pictures
- Document Properties
- Styles
- Form Controls
- Barcodes
- Theme
- Chart
- Table
- Pivot Table
- Pivot Chart
- Sparkline
- Slicer
- Print
- Logging
- Defined Names
Templates
File Operations
Release Notes

Delete Validation

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.

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