Interface IRangeDataValidation

Namespace

OfficeOpenXml.DataValidation

Assembly

EPPlus.dll

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

public interface IRangeDataValidation

Methods

AddAnyDataValidation()

Adds a IExcelDataValidationAny to the range.

IExcelDataValidationAny AddAnyDataValidation()

Returns

IExcelDataValidationAny

A ExcelDataValidationAny that can be configured for any validation

AddCustomDataValidation()

Adds a IExcelDataValidationCustom to the range.

IExcelDataValidationCustom AddCustomDataValidation()

Returns

IExcelDataValidationCustom

A IExcelDataValidationCustom that can be configured for custom validation

AddDateTimeDataValidation()

Adds a ExcelDataValidationDateTime to the range

IExcelDataValidationDateTime AddDateTimeDataValidation()

Returns

IExcelDataValidationDateTime

A ExcelDataValidationDecimal that can be configured for datetime data validation

AddDecimalDataValidation()

Adds a ExcelDataValidationDecimal to the range

IExcelDataValidationDecimal AddDecimalDataValidation()

Returns

IExcelDataValidationDecimal

A ExcelDataValidationDecimal that can be configured for decimal data validation

AddIntegerDataValidation()

Adds a ExcelDataValidationInt to the range

IExcelDataValidationInt AddIntegerDataValidation()

Returns

IExcelDataValidationInt

A ExcelDataValidationInt that can be configured for integer data validation

AddListDataValidation()

Adds a IExcelDataValidationList to the range

IExcelDataValidationList AddListDataValidation()

Returns

IExcelDataValidationList

A ExcelDataValidationList that can be configured for datetime data validation

AddTextLengthDataValidation()

Adds a ExcelDataValidationInt regarding text length validation to the range.

IExcelDataValidationInt AddTextLengthDataValidation()

Returns

IExcelDataValidationInt

AddTimeDataValidation()

Adds a IExcelDataValidationTime to the range.

IExcelDataValidationTime AddTimeDataValidation()

Returns

IExcelDataValidationTime

A IExcelDataValidationTime that can be configured for time data validation

ClearDataValidation(bool)

Removes validation from the cell/range

void ClearDataValidation(bool deleteIfEmpty = false)

Parameters

deleteIfEmpty bool

Delete the validation if it has no more addresses its being applied to. If set to false an InvalidOperationException will be thrown if all addresses of a datavalidation has been cleared.

Exceptions

InvalidOperationException

Thrown if deleteIfEmpty is false and all addresses of a datavalidation has been cleared.