Find And Replace Cells
Find and replace the cell value in google sheet.
Last updated
Find and replace the cell value in google sheet.
Last updated
Search the specified cell value or regex in a google spreadsheet and replaced it with replace value.
Credential: A variable name that references the user credential to access the resources.
SpreadSheet Id: The Id of the spreadsheet in which cell value is to be searched.
Sheet Name: The name of the sheet in which the value is to be searched.Set this property only when the Search type is Sheet.
Range: 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: The cell value is to be searched. Search value is a regex if Search By Regex property is true.
Replace Value: The cell value is to be replaced.
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:
True
- Search value is a regex.
False
- Search value is not a regex.
Include Formula:
True
- Search should include cells with formulas.
False
- Search does not include cells with formulas.
Match Entire Cell:
True
- find value should match the entire cell.
False
- find value does not match the entire cell.
Search Case:
True
- Search is case sensitive.
False
- Search is not case sensitive.