Skip to main content
Glama
Sign In
enesjakozh

Excel MCP Server

by yzfly
GitHub
Python
2
RedditDiscord
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

filter_excel

Filter Excel data by applying a pandas query string to extract specific rows or columns. Specify the file path, query, and optional sheet name to retrieve filtered results efficiently.

Instructions

Filter Excel data using a pandas query string. Args: file_path: Path to the Excel file query: Pandas query string (e.g., "Age > 30 and Department == 'Sales'") sheet_name: Name of the sheet to filter (for Excel files) Returns: Filtered data as string

Input Schema

NameRequiredDescriptionDefault
file_pathYes
queryYes
sheet_nameNo

Input Schema (JSON Schema)

{ "properties": { "file_path": { "title": "File Path", "type": "string" }, "query": { "title": "Query", "type": "string" }, "sheet_name": { "anyOf": [ { "type": "string" }, { "type": "null" } ], "default": null, "title": "Sheet Name" } }, "required": [ "file_path", "query" ], "title": "filter_excelArguments", "type": "object" }

You must be authenticated.

Other Tools from Excel MCP Server

Related Tools

ID: vda5rccucp