Find/Replace Value
Finds cells whose displayed value matches, and optionally replaces it. Formula cells are found but never rewritten.
Behaviour
Risk: Low · Idempotent: No · Safe to retry: No · Recovery: Not replayed after a crash
Package Excel activities Velophex.Excel.Activities 0.7.1-rc.7 · Supported (Core profile) · type id velophex.excel.findReplace
Properties#
Input#
Sheet#
Sheet · String · Required · Default: Sheet1
The name of the sheet.
Range#
Range · String · Optional · Default: Not specified in package metadata
The range to search. Empty searches the used range.
Find#
Find · String · Required · Default: Not specified in package metadata
The text to find.
Replace With#
ReplaceWith · String · Optional · Default: Not specified in package metadata
The replacement. Empty only finds.
Workbook#
Workbook · ExcelWorkbookReference · Optional · Default: Not specified in package metadata
The Excel file to use. Empty uses the innermost enclosing Use Excel File; set it to the Reference As name of a Use Excel File to use that one.
Options#
Match Case#
MatchCase · Boolean · Optional · Default: False
Upper and lower case must match.
Match Entire Cell#
MatchEntireCell · Boolean · Optional · Default: False
The whole cell must equal Find.
All Matches#
AllMatches · Boolean · Optional · Default: True
Find (and replace) every match, not only the first.
Output#
Found Cell#
FoundCell · String · Output
The address of the first match, or null.
Count#
Count · Int32 · Output
How many cells matched.
Rules#
- Must be inside Use Excel File.
Retry and risk#
This activity is not marked safe to retry: if it fails partway, check whether its work already happened before running it again. If a run is interrupted and the outcome of a step is unknown, the step is never retried automatically (what to do). How activities declare this: characteristics, retries and risk.
Every activity also has the engine's common properties: Timeout and Continue On Error.
Related activities#
- Append Range (Excel)
- Auto Fill
- Auto Fit Range
- Clear Range
- Copy Paste Range
- Copy Sheet
- Create Sheet
- Create Table
Generated from Velophex.Excel.Activities 0.7.1-rc.7. Category: Excel. Keywords: excel, workbook, xlsx, spreadsheet, find, replace, search, value.
Properties
Input
Options
Output
Rules
Retry and risk
Related activities