files_replace
Finds and replaces text across cells in one transaction (the write counterpart of files_search). Only TEXT cells are changed — numbers, formulas, and code are left untouched. case_sensitive (default false) and whole_cell (default false: substring match; true: only cells equal to find). sheet scopes the replace to one sheet (defaults to all sheets). Returns { replaced: , skipped: <matches left as-is: numbers, formula output, table cells> }. Requires edit permission. Signature: files_replace(file_uuid, find, replace, sheet?, case_sensitive?, whole_cell?).
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"file_uuid": "<file_uuid>",
"find": "<find>",
"replace": "<replace>"
},
"name": "files_replace"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| find | Yes | Text to search for. | |
| sheet | No | Limit to this sheet (defaults to all sheets). | |
| replace | Yes | Replacement text (use empty string to delete the matched text). | |
| file_uuid | Yes | ||
| whole_cell | No | Only replace cells equal to 'find' (default false). | |
| case_sensitive | No | Match case (default false). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| note | No | ||
| skipped | Yes | ||
| replaced | Yes | ||
| file_uuid | Yes | ||
| sequence_number | No |