Class FindReplaceRequest

Finds and replaces data in cells over a range, sheet, or all sheets.

Inheritance

System.Object

FindReplaceRequest

Implements

IDirectResponseSchema

Namespace: Google.Apis.Sheets.v4.Data

Assembly: Google.Apis.Sheets.v4.dll

Syntax

public class FindReplaceRequest : object, IDirectResponseSchema

Properties

AllSheets

True to find/replace over all sheets.

Declaration

public virtual Nullable<bool> AllSheets { get; set; }

Property Value

Type	Description
System.Nullable<System.Boolean>

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
System.String

Find

The value to search.

Declaration

public virtual string Find { get; set; }

Property Value

Type	Description
System.String

IncludeFormulas

True if the search should include cells with formulas. False to skip cells with formulas.

Declaration

public virtual Nullable<bool> IncludeFormulas { get; set; }

Property Value

Type	Description
System.Nullable<System.Boolean>

MatchCase

True if the search is case sensitive.

Declaration

public virtual Nullable<bool> MatchCase { get; set; }

Property Value

Type	Description
System.Nullable<System.Boolean>

MatchEntireCell

True if the find value should match the entire cell.

Declaration

public virtual Nullable<bool> MatchEntireCell { get; set; }

Property Value

Type	Description
System.Nullable<System.Boolean>

Range

The range to find/replace over.

Declaration

public virtual GridRange Range { get; set; }

Property Value

Type	Description
GridRange

Replacement

The value to use as the replacement.

Declaration

public virtual string Replacement { get; set; }

Property Value

Type	Description
System.String

SearchByRegex

True if the find value is a regex. The regular expression and replacement should follow Java regex rules at https://docs.oracle.com/javase/8/docs/api/java/util/regex/Pattern.html. The replacement string is allowed to refer to capturing groups. For example, if one cell has the contents "Google Sheets" and another has "Google Docs", then searching for "o.* (.*)" with a replacement of "$1 Rocks" would change the contents of the cells to "GSheets Rocks" and "GDocs Rocks" respectively.

Declaration

public virtual Nullable<bool> SearchByRegex { get; set; }

Property Value

Type	Description
System.Nullable<System.Boolean>

SheetId

The sheet to find/replace over.

Declaration

public virtual Nullable<int> SheetId { get; set; }

Property Value

Type	Description
System.Nullable<System.Int32>

Implements

IDirectResponseSchema