Table of Contents

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()