FILTER_XLSX
Filters rows matching a condition and saves or returns the result. Condition examples: 'Sales > 1000', 'City == "NYC"', 'Age >= 30'.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
path | string | yes | Absolute path to the file |
condition | string | yes | Pandas query condition string |
output_path | string | — | Save filtered data to this path (optional, if omitted just returns data) |
sheet_name | string | — | Sheet name (default: first) |
How to use it
You normally trigger this by describing what you want in chat — the agent selects FILTER_XLSX automatically. For example:
Try saying
“use xlsx handler to filter …”
In a workflow
As a step in a multi-step workflow DAG:
json
{
"id": "s1",
"agent": "xlsx_handler",
"action": "FILTER_XLSX",
"args": {
"path": "/Users/me/Documents/file.txt",
"condition": "…"
},
"depends_on": [],
"outputs": []
}Direct call
For scripting, call it directly via POST /execute_tool. Every tool returns { success, message, data }.
bash
curl -X POST http://127.0.0.1:8000/execute_tool \
-H "Content-Type: application/json" \
-d '{"tool_name":"FILTER_XLSX","args":{"path":"/Users/me/Documents/file.txt","condition":"…"}}'Part of the xlsx_handler plugin. Browse the full Plugin & Tool Catalog or the relevant feature guide.