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