Namespace EasyXLS.Constants

Class 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

    • Field Detail

      • VALIDATE_ANY_VALUE

        public const 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 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 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 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 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 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 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 int VALIDATE_CUSTOM
        A constant indicating a custom validation type. Embedded value is "7".
        See Also:
        Constant Values

      • OPERATOR_BETWEEN

        public const int OPERATOR_BETWEEN
        A constant indicating the "between" operator. Embedded value is "0".
        See Also:
        Constant Values

      • OPERATOR_NOT_BETWEEN

        public const int OPERATOR_NOT_BETWEEN
        A constant indicating the "not between" operator. Embedded value is "1".
        See Also:
        Constant Values

      • OPERATOR_EQUAL_TO

        public const 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 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 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 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 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 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 int ERROR_STOP
        A constant indicating the "Error message" box type. Embedded value is "0".
        See Also:
        Constant Values

      • ERROR_WARNING

        public const int ERROR_WARNING
        A constant indicating the "Error message" box type. Embedded value is "1".
        See Also:
        Constant Values

      • ERROR_INFO

        public const int ERROR_INFO
        A constant indicating the "Error message" box type. Embedded value is "2".
        See Also:
        Constant Values

    • Constructor Detail

      • DataValidator

        public DataValidator()