get_data_validation_info
Extract and analyze data validation rules from an Excel worksheet to identify cell ranges and applied validation types. Returns results in JSON format for detailed insights.
Instructions
Get all data validation rules in a worksheet.
This tool helps identify which cell ranges have validation rules
and what types of validation are applied.
Args:
filepath: Path to Excel file
sheet_name: Name of worksheet
Returns:
JSON string containing all validation rules in the worksheet
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filepath | Yes | ||
| sheet_name | Yes |
Input Schema (JSON Schema)
{
"properties": {
"filepath": {
"title": "Filepath",
"type": "string"
},
"sheet_name": {
"title": "Sheet Name",
"type": "string"
}
},
"required": [
"filepath",
"sheet_name"
],
"title": "get_data_validation_infoArguments",
"type": "object"
}