find_cells
Search cells across all or one sheet by text, regex, or number, checking values, formulas, or both, and return each matching sheet, address, value, and formula.
Instructions
Find cells across all sheets (or one) and return their addresses.
mode: 'text' (substring), 'regex' (Python regular expression), or 'number' (numeric cells equal to the query, e.g. '1234.5'). search_in: 'values' (cached results / constants), 'formulas' (formula text, e.g. find every cell that uses VLOOKUP), or 'both' (default). Case-insensitive search also folds Turkish letters (dotted/dotless i, and u o s c g with their Turkish marks), so 'istanbul' finds 'İstanbul' and 'urun' finds 'Ürün'. Each hit shows the sheet, address, value and formula.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| mode | No | text | |
| path | Yes | ||
| query | Yes | ||
| sheet | No | ||
| search_in | No | both | |
| max_results | No | ||
| case_sensitive | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |