ExcelDataValidator Class

Represents a data type validator for a range of cells.

Inheritance Hierarchy

SystemObject
ExpertXls.ExcelLibExcelDataValidator

Namespace: ExpertXls.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 9.0.0

Syntax

public class ExcelDataValidator

Public Class ExcelDataValidator

The ExcelDataValidator type exposes the following members.

Properties

	Name	Description
	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.