Struct FindReplaceRequest

pub struct FindReplaceRequest {
    pub all_sheets: Option<bool>,
    pub find: Option<String>,
    pub include_formulas: Option<bool>,
    pub match_case: Option<bool>,
    pub match_entire_cell: Option<bool>,
    pub range: Option<GridRange>,
    pub replacement: Option<String>,
    pub search_by_regex: Option<bool>,
    pub sheet_id: Option<i32>,
}

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

This type is not used in any activity, and only used as part of another schema.

Fields

all_sheets: Option<bool>

True to find/replace over all sheets.

find: Option<String>

The value to search.

include_formulas: Option<bool>

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

match_case: Option<bool>

True if the search is case sensitive.

match_entire_cell: Option<bool>

True if the find value should match the entire cell.

range: Option<GridRange>

The range to find/replace over.

replacement: Option<String>

The value to use as the replacement.

search_by_regex: Option<bool>

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.

sheet_id: Option<i32>

The sheet to find/replace over.

Trait Implementations

impl Clone for FindReplaceRequest

fn clone(&self) -> FindReplaceRequest

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for FindReplaceRequest

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for FindReplaceRequest

fn default() -> FindReplaceRequest

Returns the “default value” for a type.

impl<'de> Deserialize<'de> for FindReplaceRequest

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Serialize for FindReplaceRequest

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Part for FindReplaceRequest