query_table
Filter, select, sort, and limit worksheet or table data from Excel files to retrieve specific rows and columns.
Instructions
Filter, project, sort, and limit worksheet or table data. Filters support eq/neq/ne, comparisons, string matching, blank checks, and in/not_in with value or values.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| select | No | ||
| filters | No | ||
| sort_by | No | ||
| filepath | Yes | ||
| row_mode | No | arrays | |
| sort_desc | No | ||
| header_row | No | ||
| sheet_name | No | ||
| table_name | No | ||
| infer_schema | No |