Class ExcelDataValidation

Namespace

OfficeOpenXml.DataValidation

Assembly

Magicodes.EPPlus.dll

public abstract class ExcelDataValidation : XmlHelper, IExcelDataValidation

Inheritance

object

XmlHelper

ExcelDataValidation

Implements

IExcelDataValidation

Derived

ExcelDataValidationAny

ExcelDataValidationWithFormula<T>

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

ExtensionMethods.IsNumeric(object)

Fields

_formula1Path

protected readonly string _formula1Path

Field Value

string

_formula2Path

protected readonly string _formula2Path

Field Value

string

Properties

Address

public ExcelAddress Address { get; }

Property Value

ExcelAddress

AllowBlank

public bool? AllowBlank { get; set; }

Property Value

bool?

AllowsOperator

public bool AllowsOperator { get; }

Property Value

bool

Error

public string Error { get; set; }

Property Value

string

ErrorStyle

public ExcelDataValidationWarningStyle ErrorStyle { get; set; }

Property Value

ExcelDataValidationWarningStyle

ErrorTitle

public string ErrorTitle { get; set; }

Property Value

string

Formula1Internal

protected string Formula1Internal { get; }

Property Value

string

Formula2Internal

protected string Formula2Internal { get; }

Property Value

string

Operator

public ExcelDataValidationOperator Operator { get; set; }

Property Value

ExcelDataValidationOperator

Prompt

public string Prompt { get; set; }

Property Value

string

PromptTitle

public string PromptTitle { get; set; }

Property Value

string

ShowErrorMessage

public bool? ShowErrorMessage { get; set; }

Property Value

bool?

ShowInputMessage

public bool? ShowInputMessage { get; set; }

Property Value

bool?

ValidationType

public ExcelDataValidationType ValidationType { get; }

Property Value

ExcelDataValidationType

Methods

SetValue<T>(T?, string)

protected void SetValue<T>(T? val, string path) where T : struct

Parameters

val T?

path string

Type Parameters

T

Validate()

public virtual void Validate()