Interface IExcelDataValidation¶

Namespace: OfficeOpenXml.DataValidation.Contracts
Assembly: EPPlus.dll

A generic interface for all data validations. Specialized implementation interfaces should inherit this interface.

public interface IExcelDataValidation

Properties¶

Address¶

Address of data validation

ExcelAddress Address { get; }

Property Value¶

ExcelAddress

AllowBlank¶

True if input message should be shown

bool? AllowBlank { get; set; }

Property Value¶

bool?

AllowsOperator¶

True if the current validation type allows operator.

bool AllowsOperator { get; }

Property Value¶

bool

As¶

Use this property to cast an instance of IExcelDataValidation to its subtype, see ExcelDataValidationAsType.

ExcelDataValidationAsType As { get; }

Property Value¶

ExcelDataValidationAsType

Error¶

Error message box text (see property ShowErrorMessage)

string Error { get; set; }

Property Value¶

string

ErrorStyle¶

Controls how Excel will handle invalid values.

ExcelDataValidationWarningStyle ErrorStyle { get; set; }

Property Value¶

ExcelDataValidationWarningStyle

ErrorTitle¶

Title of error message box (see property ShowErrorMessage)

string ErrorTitle { get; set; }

Property Value¶

string

ImeMode¶

Defines mode for Input Method Editor used in east-asian languages

ExcelDataValidationImeMode ImeMode { get; set; }

Property Value¶

ExcelDataValidationImeMode

IsStale¶

Indicates whether this instance is stale, see https://github.com/EPPlusSoftware/EPPlus/wiki/Data-validation-Exceptions

bool IsStale { get; }

Property Value¶

bool

Prompt¶

Info message text (see property ShowErrorMessage)

string Prompt { get; set; }

Property Value¶

string

PromptTitle¶

Title of info box if input message should be shown (see property ShowInputMessage)

string PromptTitle { get; set; }

Property Value¶

string

ShowErrorMessage¶

True if error message should be shown.

bool? ShowErrorMessage { get; set; }

Property Value¶

bool?

ShowInputMessage¶

True if input message should be shown

bool? ShowInputMessage { get; set; }

Property Value¶

bool?

Uid¶

Unique id of the data validation

string Uid { get; }

Property Value¶

string

ValidationType¶

Validation type

ExcelDataValidationType ValidationType { get; }

Property Value¶

ExcelDataValidationType

Methods¶

Validate()¶

Validates the state of the validation.

void Validate()