Skip to main content
Glama

xlwings Excel MCP Server

by hyunjae-labs

get_data_validation_info

Identify cell ranges with validation rules and their types in an Excel worksheet. Returns a JSON string detailing all validation rules for specified file and sheet.

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

NameRequiredDescriptionDefault
filepathYes
sheet_nameYes

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" }

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/hyunjae-labs/xlwings-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server