OfficeOpenXml.DataValidation Namespace

Office Open XML

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.