Contains classes for Datavalidation
Classes
| Class | Description | |
|---|---|---|
|
ExcelDataValidation |
Excel datavalidation
|
|
|
ExcelDataValidationCollection |
Collection of ExcelDataValidation. This class is providing the API for EPPlus data validation. The public methods of this class (Add[...]Validation) will create a datavalidation entry in the worksheet. When this validation has been created changes to the properties will affect the workbook immediately. Each type of validation has either a formula or a typed value/values, except for custom validation which has a formula only.  CopyC#// Add a date time validation var validation = worksheet.DataValidation.AddDateTimeValidation("A1"); // set validation properties validation.ShowErrorMessage = true; validation.ErrorTitle = "An invalid date was entered"; validation.Error = "The date must be between 2011-01-31 and 2011-12-31"; validation.Prompt = "Enter date here"; validation.Formula.Value = DateTime.Parse("2011-01-01"); validation.Formula2.Value = DateTime.Parse("2011-12-31"); validation.Operator = ExcelDataValidationOperator.between; |
|
|
ExcelDataValidationCustom |
Custom validation, i.e. a formula.
|
|
|
ExcelDataValidationDateTime |
Validation for DateTime.
|
|
|
ExcelDataValidationDecimal |
Data validation for decimal values
|
|
|
ExcelDataValidationInt |
Data validation for integer values.
|
|
|
ExcelDataValidationList |
This class represents an List data validation.
|
|
|
ExcelDataValidationTime |
Validation for times (ExcelTime).
|
|
|
ExcelDataValidationType |
Types of datavalidation
|
|
|
ExcelDataValidationWithFormula<(Of <(T>)>) |
A validation containing a formula
|
|
|
ExcelDataValidationWithFormula2<(Of <(T>)>) | |
|
|
ExcelTime |
Represents a time between 00:00:00 and 23:59:59
|
Interfaces
| Interface | Description | |
|---|---|---|
|
IRangeDataValidation |
Provides functionality for adding datavalidation to a range (ExcelRangeBase). Each method will
return a configurable validation.
|
Enumerations
| Enumeration | Description | |
|---|---|---|
|
eDataValidationType |
Enum for available data validation types
|
|
|
ExcelDataValidationOperator |
Operator for comparison between Formula and Formula2 in a validation.
|
|
|
ExcelDataValidationWarningStyle |
warning style, controls how Excel will handle invalid changes.
|
