query_sheet
Filter and retrieve specific Excel sheet rows using pandas expressions, returning only selected columns and limited rows to reduce LLM context usage.
Instructions
Query sheet data using pandas expressions without returning the entire sheet into the LLM context.
Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. filter_query: Pandas query expression (e.g. "status == 'PAID' and amount > 500"). columns: Optional list of columns to return. max_rows: Maximum rows to return (default 100). cell_range: Optional range to restrict reading before querying.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | No | ||
| sheet | Yes | ||
| columns | No | ||
| max_rows | No | ||
| cell_range | No | ||
| filter_query | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||