Find and Replace
find_replaceSearch for text in open Excel workbooks and replace it, optionally targeting a specific sheet, with case-sensitive and whole-cell matching options. Returns a JSON list of sheets that had replacements.
Instructions
Find and replace text in an open workbook.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = every sheet in the workbook). find_text: Text to search for (required). replace_text: Replacement text. match_case: Case-sensitive match. whole_cell: Match the entire cell contents rather than a substring.
Returns: JSON with which sheets had at least one replacement.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | No | ||
| workbook | No | ||
| find_text | No | ||
| match_case | No | ||
| whole_cell | No | ||
| replace_text | No |