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.