ExcelDataValidator Class

Represents a data type validator for a range of cells.

Definition

Namespace: Winnovative.ExcelLib
Assembly: WnvXls_NetCore (in WnvXls_NetCore.dll) Version: 12.0.0

C#

public class ExcelDataValidator

VB

Public Class ExcelDataValidator

C++

public ref class ExcelDataValidator

F#

type ExcelDataValidator = class end

AllowedDataType	Gets or sets the data type of the values allowed by this validator.
AllowedValues	Gets or sets the list of possible string values for a cell.
ErrorAlertStyle	Gets or sets the style of the error alert.
ErrorAlertText	Gets or sets the text of the error alert to be shown when user enters invalid data.
ErrorAlertTitle	Gets or sets the title of the error alert to be shown when user enters invalid data.
InCellDropDown	Gets or sets a flag indicating if the drop down list with allowed values is displayed in cell. Default value is true.
InputMessageText	Gets or sets the text of the input message to be shown when the cell to be validated is selected.
InputMessageTitle	Gets or sets the title of the input message to be shown when the cell to be validated is selected.
Operator	Gets or sets the operator for data validation.
ShowErrorAlert	Gets or sets a flag indicating if the error alert is shown when user enters invalid data.
ShowInputMessage	Gets or sets a flag indicating if the input message is shown when the cell to be validated is selected.
Value1	Gets or sets the first value or expression for data validation.
Value2	Gets or sets the second value or expression for data validation.