excel_data_validation
Apply data validation rules to Excel ranges to restrict input types, ensure data integrity, and maintain spreadsheet accuracy for financial calculations.
Instructions
Add data validation to a range
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | ||
| validation | Yes | ||
| worksheetName | Yes |
Input Schema (JSON Schema)
{
"properties": {
"range": {
"type": "string"
},
"validation": {
"properties": {
"allowBlank": {
"type": "boolean"
},
"error": {
"type": "string"
},
"errorTitle": {
"type": "string"
},
"formula1": {
"type": "string"
},
"formula2": {
"type": "string"
},
"operator": {
"type": "string"
},
"prompt": {
"type": "string"
},
"promptTitle": {
"type": "string"
},
"showErrorMessage": {
"type": "boolean"
},
"showInputMessage": {
"type": "boolean"
},
"type": {
"type": "string"
}
},
"type": "object"
},
"worksheetName": {
"type": "string"
}
},
"required": [
"worksheetName",
"range",
"validation"
],
"type": "object"
}