Excel.DataValidationType enum
Represents the data validation type enum.
Remarks
Fields
| custom = "Custom" | The custom data validation type. |
| date = "Date" | The date data validation type. |
| decimal = "Decimal" | The decimal data validation type. |
| inconsistent = "Inconsistent" | Inconsistent means that the range has inconsistent data validation, indicating that there are different rules on different cells. |
| list = "List" | The list data validation type. |
| mixedCriteria = "MixedCriteria" | Mixed criteria means that the range has data validation present on some but not all cells. |
| none = "None" | None means allow any value, indicating that there is no data validation in the range. |
| textLength = "TextLength" | The text length data validation type. |
| time = "Time" | The time data validation type. |
| wholeNumber = "WholeNumber" | The whole number data validation type. |
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Office Add-ins