xlwings Excel MCP Server

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

{ "properties": { "filepath": { "title": "Filepath", "type": "string" }, "sheet_name": { "title": "Sheet Name", "type": "string" } }, "required": [ "filepath", "sheet_name" ], "title": "get_data_validation_infoArguments", "type": "object" }