Find And Replace Cells
Find and replace the cell value in google sheet.
Search the specified cell value or regex in a google spreadsheet and replaced it with replace value.
Input
Credential:
Object Variable
A variable name that references the user credential to access the resources.
SpreadSheet Id:
String Argument
The Id of the spreadsheet in which cell value is to be searched.
Sheet Name:
String Argument
The name of the sheet in which the value is to be searched.Set this property only when the Search type is Sheet.
Range:
String Argument
The range of the sheet in which the value is to be searched.Set this property only when the Search type is Range.
Search Value:
String Argument
The cell value is to be searched. Search value is a regex if Search By Regex property is true.
Replace Value:
String Argument
The cell value is to be replaced.
Options
Search Type: The type of search.
AllSheets
- Search all the sheets of a google spreadsheet.Sheet
- Search specified sheet of google spreadsheet.Range
- Search the specified range of sheets in a google spreadsheet.
Search By Regex:
Boolean Argument
True
- Search value is a regex.False
- Search value is not a regex.
Include Formula:
Boolean Argument
True
- Search should include cells with formulas.False
- Search does not include cells with formulas.
Match Entire Cell:
Boolean Argument
True
- find value should match the entire cell.False
- find value does not match the entire cell.
Search Case:
Boolean Argument
True
- Search is case sensitive.False
- Search is not case sensitive.
Last updated