search_workbook
Search for a substring across one or all sheets in an Excel workbook, with options to restrict by sheet, toggle case sensitivity, and limit match count for efficient lookup.
Instructions
Search cell values across one or all sheets for a substring match.
Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. query: Substring to search for. sheet: Restrict the search to one sheet; omit to search every sheet. match_case: Case-sensitive match when True. limit: Optional cap on the number of matches returned, to bound response size for large sheets.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | No | ||
| limit | No | ||
| query | Yes | ||
| sheet | No | ||
| match_case | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |