get_data_validation_info
Retrieve and analyze data validation rules in an Excel worksheet. Identify cell ranges and validation types by providing the file path and sheet name, returning results in JSON format.
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"
}