Namespace EasyXLS.Constants

Class DataValidator

System.Object

EasyXLS.Constants.DataValidator

public class DataValidator
extends System.Object

This class contains the constants for creating a data validator

Constant Summary

Fields

Modifier and Type	Field	Description
const int	ERROR_INFO	A constant indicating the "Error message" box type.
const int	ERROR_STOP	A constant indicating the "Error message" box type.
const int	ERROR_WARNING	A constant indicating the "Error message" box type.
const int	OPERATOR_BETWEEN	A constant indicating the "between" operator.
const int	OPERATOR_EQUAL_TO	A constant indicating the "equal to" operator.
const int	OPERATOR_GREATER_THAN	A constant indicating the "greater than to" operator.
const int	OPERATOR_GREATER_THAN_OR_EQUAL_TO	A constant indicating the "greater than or equal to" operator.
const int	OPERATOR_LESS_THAN	A constant indicating the "less than" operator.
const int	OPERATOR_LESS_THAN_OR_EQUAL_TO	A constant indicating the "less than or equal to" operator.
const int	OPERATOR_NOT_BETWEEN	A constant indicating the "not between" operator.
const int	OPERATOR_NOT_EQUAL_TO	A constant indicating the "non equal to" operator.
const int	VALIDATE_ANY_VALUE	A constant indicating a validation type that allows for any value to be entered in a cell.
const int	VALIDATE_CUSTOM	A constant indicating a custom validation type.
const int	VALIDATE_DATE	A constant indicating a validation type that only allows dates to be entered in cell.
const int	VALIDATE_DECIMAL	A constant indicating a validation type that only allows for decimals to be entered in a cell.
const int	VALIDATE_LIST	A constant indicating a validation type that only allows values from a specified list to be entered in cell.
const int	VALIDATE_TEXT_LENGTH	A constant indicating a validation type that only allows strings limited to a number of characters to be entered in cell.
const int	VALIDATE_TIME	A constant indicating a validation type that only allows for dates to be entered in a cell.
const int	VALIDATE_WHOLE_NUMBER	A constant indicating a validation type that only allows integers to be entered in cell.

Constructor Summary

Constructors

Constructor	Description
DataValidator()

Method Summary

Methods inherited from class System.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

VALIDATE_ANY_VALUE

public const final int VALIDATE_ANY_VALUE

A constant indicating a validation type that allows for any value to be entered in a cell. Embedded value is "0".

See Also:

• Constant Values

VALIDATE_WHOLE_NUMBER

public const final int VALIDATE_WHOLE_NUMBER

A constant indicating a validation type that only allows integers to be entered in cell. Embedded value is "1".

See Also:

• Constant Values

VALIDATE_DECIMAL

public const final int VALIDATE_DECIMAL

A constant indicating a validation type that only allows for decimals to be entered in a cell. Embedded value is "2".

See Also:

• Constant Values

VALIDATE_LIST

public const final int VALIDATE_LIST

A constant indicating a validation type that only allows values from a specified list to be entered in cell. Embedded value is "3".

See Also:

• Constant Values

VALIDATE_DATE

public const final int VALIDATE_DATE

A constant indicating a validation type that only allows dates to be entered in cell. Embedded value is "4".

See Also:

• Constant Values

VALIDATE_TIME

public const final int VALIDATE_TIME

A constant indicating a validation type that only allows for dates to be entered in a cell. Embedded value is "5".

See Also:

• Constant Values

VALIDATE_TEXT_LENGTH

public const final int VALIDATE_TEXT_LENGTH

A constant indicating a validation type that only allows strings limited to a number of characters to be entered in cell. Embedded value is "6".

See Also:

• Constant Values

VALIDATE_CUSTOM

public const final int VALIDATE_CUSTOM

A constant indicating a custom validation type. Embedded value is "7".

See Also:

• Constant Values

OPERATOR_BETWEEN

public const final int OPERATOR_BETWEEN

A constant indicating the "between" operator. Embedded value is "0".

See Also:

• Constant Values

OPERATOR_NOT_BETWEEN

public const final int OPERATOR_NOT_BETWEEN

A constant indicating the "not between" operator. Embedded value is "1".

See Also:

• Constant Values

OPERATOR_EQUAL_TO

public const final int OPERATOR_EQUAL_TO

A constant indicating the "equal to" operator. Embedded value is "2".

See Also:

• Constant Values

OPERATOR_NOT_EQUAL_TO

public const final int OPERATOR_NOT_EQUAL_TO

A constant indicating the "non equal to" operator. Embedded value is "3".

See Also:

• Constant Values

OPERATOR_GREATER_THAN

public const final int OPERATOR_GREATER_THAN

A constant indicating the "greater than to" operator. Embedded value is "4".

See Also:

• Constant Values

OPERATOR_LESS_THAN

public const final int OPERATOR_LESS_THAN

A constant indicating the "less than" operator. Embedded value is "5".

See Also:

• Constant Values

OPERATOR_GREATER_THAN_OR_EQUAL_TO

public const final int OPERATOR_GREATER_THAN_OR_EQUAL_TO

A constant indicating the "greater than or equal to" operator. Embedded value is "6".

See Also:

• Constant Values

OPERATOR_LESS_THAN_OR_EQUAL_TO

public const final int OPERATOR_LESS_THAN_OR_EQUAL_TO

A constant indicating the "less than or equal to" operator. Embedded value is "7".

See Also:

• Constant Values

ERROR_STOP

public const final int ERROR_STOP

A constant indicating the "Error message" box type. Embedded value is "0".

See Also:

• Constant Values

ERROR_WARNING

public const final int ERROR_WARNING

A constant indicating the "Error message" box type. Embedded value is "1".

See Also:

• Constant Values

ERROR_INFO

public const final int ERROR_INFO

A constant indicating the "Error message" box type. Embedded value is "2".

See Also:

• Constant Values

Constructor Details

DataValidator

public DataValidator()