# ValidationType

**Kind**: enumeration | **Module**: [Excel](https://docs.interop.io/adapters/reference/javascript/excel/index.md)

**Source**: https://docs.interop.io/adapters/reference/javascript/excel/validationtype/index.html

The type of data validation applied to cells in a column.

## Members

- **`WholeNumber`** - Only whole numbers are allowed. Once the whole number option is selected, other options become available to further limit input.
- **`Decimal`** - Only decimal numbers are allowed. Once the decimal number option is selected, other options become available to further limit input.
- **`Date`** - Only dates are allowed.
- **`Time`** - Only times are allowed.
- **`TextLength`** - Validates input based on number of characters or digits.
- **`List`** - Only values from a predefined list are allowed. The values are presented to the user as a dropdown menu control.