Interface IRangeDataValidation

Provides functionality for adding datavalidation to a range (ExcelRangeBase). Each method will return a configurable validation.

Namespace: OfficeOpenXml.DataValidation

Assembly: EPPlus.dll

Syntax

public interface IRangeDataValidation

Methods

AddAnyDataValidation()

Adds a IExcelDataValidationAny to the range.

Declaration

IExcelDataValidationAny AddAnyDataValidation()

Returns

Type	Description
IExcelDataValidationAny	A ExcelDataValidationAny that can be configured for any validation

AddCustomDataValidation()

Adds a IExcelDataValidationCustom to the range.

Declaration

IExcelDataValidationCustom AddCustomDataValidation()

Returns

Type	Description
IExcelDataValidationCustom	A IExcelDataValidationCustom that can be configured for custom validation

AddDateTimeDataValidation()

Adds a ExcelDataValidationDateTime to the range

Declaration

IExcelDataValidationDateTime AddDateTimeDataValidation()

Returns

Type	Description
IExcelDataValidationDateTime	A ExcelDataValidationDecimal that can be configured for datetime data validation

AddDecimalDataValidation()

Adds a ExcelDataValidationDecimal to the range

Declaration

IExcelDataValidationDecimal AddDecimalDataValidation()

Returns

Type	Description
IExcelDataValidationDecimal	A ExcelDataValidationDecimal that can be configured for decimal data validation

AddIntegerDataValidation()

Adds a IExcelDataValidationInt to the range

Declaration

IExcelDataValidationInt AddIntegerDataValidation()

Returns

Type	Description
IExcelDataValidationInt	A ExcelDataValidationInt that can be configured for integer data validation

AddListDataValidation()

Adds a IExcelDataValidationList to the range

Declaration

IExcelDataValidationList AddListDataValidation()

Returns

Type	Description
IExcelDataValidationList	A ExcelDataValidationList that can be configured for datetime data validation

AddTextLengthDataValidation()

Adds a IExcelDataValidationInt regarding text length validation to the range.

Declaration

IExcelDataValidationInt AddTextLengthDataValidation()

Returns

Type	Description
IExcelDataValidationInt

AddTimeDataValidation()

Adds a IExcelDataValidationTime to the range.

Declaration

IExcelDataValidationTime AddTimeDataValidation()

Returns

Type	Description
IExcelDataValidationTime	A IExcelDataValidationTime that can be configured for time data validation