excel_data_validation
Apply data validation rules to Excel ranges to restrict input types, ensure data accuracy, and maintain spreadsheet integrity for financial workflows.
Instructions
Add data validation to a range
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"worksheetName": "<worksheetName>",
"range": "<range>",
"validation": "<validation>"
},
"name": "excel_data_validation"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| worksheetName | Yes | ||
| range | Yes | ||
| validation | Yes |