Find cells
find_cellsSearch Excel cells for a value or formula. Use exact or partial matching, case sensitivity, and sheet selection to find results.
Instructions
Find cells whose value contains (or equals) the query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| mode | No | 'values' returns formula results as last calculated by Excel (formulas written by this server have no result until the file is recalculated in Excel or LibreOffice, and read as null). 'formulas' returns formulas as text, e.g. '=SUM(A1:A3)'. | values |
| path | Yes | Path to an .xlsx, .xlsm, .xltx or .xltm file. Relative paths are resolved in the server's workbook directory when one is configured; otherwise use an absolute path. | |
| exact | No | Match the whole cell instead of any part of it. | |
| query | Yes | Text to look for. | |
| sheet | No | Sheet to search. Default: all sheets. | |
| max_results | No | Stop after this many matches. | |
| case_sensitive | No | Match upper and lower case exactly. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| matches | Yes | ||
| truncated | Yes |