docs: update docs (#916)
* fix: re-run script
* test: fix noxfile
diff --git a/docs/dyn/sheets_v4.spreadsheets.values.html b/docs/dyn/sheets_v4.spreadsheets.values.html
index 8adc6a0..37e867d 100644
--- a/docs/dyn/sheets_v4.spreadsheets.values.html
+++ b/docs/dyn/sheets_v4.spreadsheets.values.html
@@ -75,7 +75,7 @@
<h1><a href="sheets_v4.html">Google Sheets API</a> . <a href="sheets_v4.spreadsheets.html">spreadsheets</a> . <a href="sheets_v4.spreadsheets.values.html">values</a></h1>
<h2>Instance Methods</h2>
<p class="toc_element">
- <code><a href="#append">append(spreadsheetId, range, body=None, responseValueRenderOption=None, responseDateTimeRenderOption=None, valueInputOption=None, includeValuesInResponse=None, insertDataOption=None, x__xgafv=None)</a></code></p>
+ <code><a href="#append">append(spreadsheetId, range, body=None, valueInputOption=None, includeValuesInResponse=None, insertDataOption=None, responseValueRenderOption=None, responseDateTimeRenderOption=None, x__xgafv=None)</a></code></p>
<p class="firstline">Appends values to a spreadsheet. The input range is used to search for</p>
<p class="toc_element">
<code><a href="#batchClear">batchClear(spreadsheetId, body=None, x__xgafv=None)</a></code></p>
@@ -102,11 +102,11 @@
<code><a href="#get">get(spreadsheetId, range, dateTimeRenderOption=None, majorDimension=None, valueRenderOption=None, x__xgafv=None)</a></code></p>
<p class="firstline">Returns a range of values from a spreadsheet.</p>
<p class="toc_element">
- <code><a href="#update">update(spreadsheetId, range, body=None, responseDateTimeRenderOption=None, valueInputOption=None, includeValuesInResponse=None, responseValueRenderOption=None, x__xgafv=None)</a></code></p>
+ <code><a href="#update">update(spreadsheetId, range, body=None, responseValueRenderOption=None, responseDateTimeRenderOption=None, valueInputOption=None, includeValuesInResponse=None, x__xgafv=None)</a></code></p>
<p class="firstline">Sets values in a range of a spreadsheet.</p>
<h3>Method Details</h3>
<div class="method">
- <code class="details" id="append">append(spreadsheetId, range, body=None, responseValueRenderOption=None, responseDateTimeRenderOption=None, valueInputOption=None, includeValuesInResponse=None, insertDataOption=None, x__xgafv=None)</code>
+ <code class="details" id="append">append(spreadsheetId, range, body=None, valueInputOption=None, includeValuesInResponse=None, insertDataOption=None, responseValueRenderOption=None, responseDateTimeRenderOption=None, x__xgafv=None)</code>
<pre>Appends values to a spreadsheet. The input range is used to search for
existing data and find a "table" within that range. Values will be
appended to the next row of the table, starting with the first column of
@@ -164,17 +164,17 @@
# When writing, if this field is not set, it defaults to ROWS.
}
+ valueInputOption: string, How the input data should be interpreted.
+ includeValuesInResponse: boolean, Determines if the update response should include the values
+of the cells that were appended. By default, responses
+do not include the updated values.
+ insertDataOption: string, How the input data should be inserted.
responseValueRenderOption: string, Determines how values in the response should be rendered.
The default render option is ValueRenderOption.FORMATTED_VALUE.
responseDateTimeRenderOption: string, Determines how dates, times, and durations in the response should be
rendered. This is ignored if response_value_render_option is
FORMATTED_VALUE.
The default dateTime render option is [DateTimeRenderOption.SERIAL_NUMBER].
- valueInputOption: string, How the input data should be interpreted.
- includeValuesInResponse: boolean, Determines if the update response should include the values
-of the cells that were appended. By default, responses
-do not include the updated values.
- insertDataOption: string, How the input data should be inserted.
x__xgafv: string, V1 error format.
Allowed values
1 - v1 error format
@@ -189,6 +189,11 @@
# Empty if no table was found.
"spreadsheetId": "A String", # The spreadsheet the updates were applied to.
"updates": { # The response when updating a range of values in a spreadsheet. # Information about the updates that were applied.
+ "updatedRows": 42, # The number of rows where at least one cell in the row was updated.
+ "updatedRange": "A String", # The range (in A1 notation) that updates were applied to.
+ "updatedCells": 42, # The number of cells updated.
+ "updatedColumns": 42, # The number of columns where at least one cell in the column was updated.
+ "spreadsheetId": "A String", # The spreadsheet the updates were applied to.
"updatedData": { # Data within a range of the spreadsheet. # The values of the cells after updates were applied.
# This is only included if the request's `includeValuesInResponse` field
# was `true`.
@@ -225,11 +230,6 @@
#
# When writing, if this field is not set, it defaults to ROWS.
},
- "updatedRows": 42, # The number of rows where at least one cell in the row was updated.
- "updatedRange": "A String", # The range (in A1 notation) that updates were applied to.
- "updatedCells": 42, # The number of cells updated.
- "updatedColumns": 42, # The number of columns where at least one cell in the column was updated.
- "spreadsheetId": "A String", # The spreadsheet the updates were applied to.
},
}</pre>
</div>
@@ -261,12 +261,12 @@
An object of the form:
{ # The response when clearing a range of values in a spreadsheet.
- "spreadsheetId": "A String", # The spreadsheet the updates were applied to.
"clearedRanges": [ # The ranges that were cleared, in A1 notation. If the requests are for an
# unbounded range or a ranger larger than the bounds of the sheet, this is
# the actual ranges that were cleared, bounded to the sheet's limits.
"A String",
],
+ "spreadsheetId": "A String", # The spreadsheet the updates were applied to.
}</pre>
</div>
@@ -288,6 +288,68 @@
"dataFilters": [ # The DataFilters used to determine which ranges to clear.
{ # Filter that describes what data should be selected or returned from a
# request.
+ "developerMetadataLookup": { # Selects DeveloperMetadata that matches all of the specified fields. For # Selects data associated with the developer metadata matching the criteria
+ # described by this DeveloperMetadataLookup.
+ # example, if only a metadata ID is specified this considers the
+ # DeveloperMetadata with that particular unique ID. If a metadata key is
+ # specified, this considers all developer metadata with that key. If a
+ # key, visibility, and location type are all specified, this considers all
+ # developer metadata with that key and visibility that are associated with a
+ # location of that type. In general, this
+ # selects all DeveloperMetadata that matches the intersection of all the
+ # specified fields; any field or combination of fields may be specified.
+ "locationType": "A String", # Limits the selected developer metadata to those entries which are
+ # associated with locations of the specified type. For example, when this
+ # field is specified as ROW this lookup
+ # only considers developer metadata associated on rows. If the field is left
+ # unspecified, all location types are considered. This field cannot be
+ # specified as SPREADSHEET when
+ # the locationMatchingStrategy
+ # is specified as INTERSECTING or when the
+ # metadataLocation is specified as a
+ # non-spreadsheet location: spreadsheet metadata cannot intersect any other
+ # developer metadata location. This field also must be left unspecified when
+ # the locationMatchingStrategy
+ # is specified as EXACT.
+ "metadataKey": "A String", # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_key.
+ "locationMatchingStrategy": "A String", # Determines how this lookup matches the location. If this field is
+ # specified as EXACT, only developer metadata associated on the exact
+ # location specified is matched. If this field is specified to INTERSECTING,
+ # developer metadata associated on intersecting locations is also
+ # matched. If left unspecified, this field assumes a default value of
+ # INTERSECTING.
+ # If this field is specified, a metadataLocation
+ # must also be specified.
+ "metadataLocation": { # A location where metadata may be associated in a spreadsheet. # Limits the selected developer metadata to those entries associated with
+ # the specified location. This field either matches exact locations or all
+ # intersecting locations according the specified
+ # locationMatchingStrategy.
+ "sheetId": 42, # The ID of the sheet when metadata is associated with an entire sheet.
+ "spreadsheet": True or False, # True when metadata is associated with an entire spreadsheet.
+ "locationType": "A String", # The type of location this object represents. This field is read-only.
+ "dimensionRange": { # A range along a single dimension on a sheet. # Represents the row or column when metadata is associated with
+ # a dimension. The specified DimensionRange must represent a single row
+ # or column; it cannot be unbounded or span multiple rows or columns.
+ # All indexes are zero-based.
+ # Indexes are half open: the start index is inclusive
+ # and the end index is exclusive.
+ # Missing indexes indicate the range is unbounded on that side.
+ "dimension": "A String", # The dimension of the span.
+ "sheetId": 42, # The sheet this span is on.
+ "endIndex": 42, # The end (exclusive) of the span, or not set if unbounded.
+ "startIndex": 42, # The start (inclusive) of the span, or not set if unbounded.
+ },
+ },
+ "metadataId": 42, # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_id.
+ "visibility": "A String", # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.visibility. If left unspecified, all developer
+ # metadata visibile to the requesting project is considered.
+ "metadataValue": "A String", # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_value.
+ },
+ "a1Range": "A String", # Selects data that matches the specified A1 range.
"gridRange": { # A range on a sheet. # Selects data that matches the range described by the GridRange.
# All indexes are zero-based.
# Indexes are half open, e.g the start index is inclusive
@@ -317,74 +379,12 @@
# If the start index equals the end index, then the range is empty.
# Empty ranges are typically not meaningful and are usually rendered in the
# UI as `#REF!`.
- "endRowIndex": 42, # The end row (exclusive) of the range, or not set if unbounded.
- "startColumnIndex": 42, # The start column (inclusive) of the range, or not set if unbounded.
"sheetId": 42, # The sheet this range is on.
"endColumnIndex": 42, # The end column (exclusive) of the range, or not set if unbounded.
"startRowIndex": 42, # The start row (inclusive) of the range, or not set if unbounded.
+ "endRowIndex": 42, # The end row (exclusive) of the range, or not set if unbounded.
+ "startColumnIndex": 42, # The start column (inclusive) of the range, or not set if unbounded.
},
- "developerMetadataLookup": { # Selects DeveloperMetadata that matches all of the specified fields. For # Selects data associated with the developer metadata matching the criteria
- # described by this DeveloperMetadataLookup.
- # example, if only a metadata ID is specified this considers the
- # DeveloperMetadata with that particular unique ID. If a metadata key is
- # specified, this considers all developer metadata with that key. If a
- # key, visibility, and location type are all specified, this considers all
- # developer metadata with that key and visibility that are associated with a
- # location of that type. In general, this
- # selects all DeveloperMetadata that matches the intersection of all the
- # specified fields; any field or combination of fields may be specified.
- "metadataLocation": { # A location where metadata may be associated in a spreadsheet. # Limits the selected developer metadata to those entries associated with
- # the specified location. This field either matches exact locations or all
- # intersecting locations according the specified
- # locationMatchingStrategy.
- "sheetId": 42, # The ID of the sheet when metadata is associated with an entire sheet.
- "spreadsheet": True or False, # True when metadata is associated with an entire spreadsheet.
- "locationType": "A String", # The type of location this object represents. This field is read-only.
- "dimensionRange": { # A range along a single dimension on a sheet. # Represents the row or column when metadata is associated with
- # a dimension. The specified DimensionRange must represent a single row
- # or column; it cannot be unbounded or span multiple rows or columns.
- # All indexes are zero-based.
- # Indexes are half open: the start index is inclusive
- # and the end index is exclusive.
- # Missing indexes indicate the range is unbounded on that side.
- "sheetId": 42, # The sheet this span is on.
- "endIndex": 42, # The end (exclusive) of the span, or not set if unbounded.
- "startIndex": 42, # The start (inclusive) of the span, or not set if unbounded.
- "dimension": "A String", # The dimension of the span.
- },
- },
- "metadataId": 42, # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.metadata_id.
- "visibility": "A String", # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.visibility. If left unspecified, all developer
- # metadata visibile to the requesting project is considered.
- "metadataValue": "A String", # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.metadata_value.
- "locationType": "A String", # Limits the selected developer metadata to those entries which are
- # associated with locations of the specified type. For example, when this
- # field is specified as ROW this lookup
- # only considers developer metadata associated on rows. If the field is left
- # unspecified, all location types are considered. This field cannot be
- # specified as SPREADSHEET when
- # the locationMatchingStrategy
- # is specified as INTERSECTING or when the
- # metadataLocation is specified as a
- # non-spreadsheet location: spreadsheet metadata cannot intersect any other
- # developer metadata location. This field also must be left unspecified when
- # the locationMatchingStrategy
- # is specified as EXACT.
- "locationMatchingStrategy": "A String", # Determines how this lookup matches the location. If this field is
- # specified as EXACT, only developer metadata associated on the exact
- # location specified is matched. If this field is specified to INTERSECTING,
- # developer metadata associated on intersecting locations is also
- # matched. If left unspecified, this field assumes a default value of
- # INTERSECTING.
- # If this field is specified, a metadataLocation
- # must also be specified.
- "metadataKey": "A String", # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.metadata_key.
- },
- "a1Range": "A String", # Selects data that matches the specified A1 range.
},
],
}
@@ -508,6 +508,68 @@
# that match any of the specified data filters are included in the response.
{ # Filter that describes what data should be selected or returned from a
# request.
+ "developerMetadataLookup": { # Selects DeveloperMetadata that matches all of the specified fields. For # Selects data associated with the developer metadata matching the criteria
+ # described by this DeveloperMetadataLookup.
+ # example, if only a metadata ID is specified this considers the
+ # DeveloperMetadata with that particular unique ID. If a metadata key is
+ # specified, this considers all developer metadata with that key. If a
+ # key, visibility, and location type are all specified, this considers all
+ # developer metadata with that key and visibility that are associated with a
+ # location of that type. In general, this
+ # selects all DeveloperMetadata that matches the intersection of all the
+ # specified fields; any field or combination of fields may be specified.
+ "locationType": "A String", # Limits the selected developer metadata to those entries which are
+ # associated with locations of the specified type. For example, when this
+ # field is specified as ROW this lookup
+ # only considers developer metadata associated on rows. If the field is left
+ # unspecified, all location types are considered. This field cannot be
+ # specified as SPREADSHEET when
+ # the locationMatchingStrategy
+ # is specified as INTERSECTING or when the
+ # metadataLocation is specified as a
+ # non-spreadsheet location: spreadsheet metadata cannot intersect any other
+ # developer metadata location. This field also must be left unspecified when
+ # the locationMatchingStrategy
+ # is specified as EXACT.
+ "metadataKey": "A String", # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_key.
+ "locationMatchingStrategy": "A String", # Determines how this lookup matches the location. If this field is
+ # specified as EXACT, only developer metadata associated on the exact
+ # location specified is matched. If this field is specified to INTERSECTING,
+ # developer metadata associated on intersecting locations is also
+ # matched. If left unspecified, this field assumes a default value of
+ # INTERSECTING.
+ # If this field is specified, a metadataLocation
+ # must also be specified.
+ "metadataLocation": { # A location where metadata may be associated in a spreadsheet. # Limits the selected developer metadata to those entries associated with
+ # the specified location. This field either matches exact locations or all
+ # intersecting locations according the specified
+ # locationMatchingStrategy.
+ "sheetId": 42, # The ID of the sheet when metadata is associated with an entire sheet.
+ "spreadsheet": True or False, # True when metadata is associated with an entire spreadsheet.
+ "locationType": "A String", # The type of location this object represents. This field is read-only.
+ "dimensionRange": { # A range along a single dimension on a sheet. # Represents the row or column when metadata is associated with
+ # a dimension. The specified DimensionRange must represent a single row
+ # or column; it cannot be unbounded or span multiple rows or columns.
+ # All indexes are zero-based.
+ # Indexes are half open: the start index is inclusive
+ # and the end index is exclusive.
+ # Missing indexes indicate the range is unbounded on that side.
+ "dimension": "A String", # The dimension of the span.
+ "sheetId": 42, # The sheet this span is on.
+ "endIndex": 42, # The end (exclusive) of the span, or not set if unbounded.
+ "startIndex": 42, # The start (inclusive) of the span, or not set if unbounded.
+ },
+ },
+ "metadataId": 42, # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_id.
+ "visibility": "A String", # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.visibility. If left unspecified, all developer
+ # metadata visibile to the requesting project is considered.
+ "metadataValue": "A String", # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_value.
+ },
+ "a1Range": "A String", # Selects data that matches the specified A1 range.
"gridRange": { # A range on a sheet. # Selects data that matches the range described by the GridRange.
# All indexes are zero-based.
# Indexes are half open, e.g the start index is inclusive
@@ -537,74 +599,12 @@
# If the start index equals the end index, then the range is empty.
# Empty ranges are typically not meaningful and are usually rendered in the
# UI as `#REF!`.
- "endRowIndex": 42, # The end row (exclusive) of the range, or not set if unbounded.
- "startColumnIndex": 42, # The start column (inclusive) of the range, or not set if unbounded.
"sheetId": 42, # The sheet this range is on.
"endColumnIndex": 42, # The end column (exclusive) of the range, or not set if unbounded.
"startRowIndex": 42, # The start row (inclusive) of the range, or not set if unbounded.
+ "endRowIndex": 42, # The end row (exclusive) of the range, or not set if unbounded.
+ "startColumnIndex": 42, # The start column (inclusive) of the range, or not set if unbounded.
},
- "developerMetadataLookup": { # Selects DeveloperMetadata that matches all of the specified fields. For # Selects data associated with the developer metadata matching the criteria
- # described by this DeveloperMetadataLookup.
- # example, if only a metadata ID is specified this considers the
- # DeveloperMetadata with that particular unique ID. If a metadata key is
- # specified, this considers all developer metadata with that key. If a
- # key, visibility, and location type are all specified, this considers all
- # developer metadata with that key and visibility that are associated with a
- # location of that type. In general, this
- # selects all DeveloperMetadata that matches the intersection of all the
- # specified fields; any field or combination of fields may be specified.
- "metadataLocation": { # A location where metadata may be associated in a spreadsheet. # Limits the selected developer metadata to those entries associated with
- # the specified location. This field either matches exact locations or all
- # intersecting locations according the specified
- # locationMatchingStrategy.
- "sheetId": 42, # The ID of the sheet when metadata is associated with an entire sheet.
- "spreadsheet": True or False, # True when metadata is associated with an entire spreadsheet.
- "locationType": "A String", # The type of location this object represents. This field is read-only.
- "dimensionRange": { # A range along a single dimension on a sheet. # Represents the row or column when metadata is associated with
- # a dimension. The specified DimensionRange must represent a single row
- # or column; it cannot be unbounded or span multiple rows or columns.
- # All indexes are zero-based.
- # Indexes are half open: the start index is inclusive
- # and the end index is exclusive.
- # Missing indexes indicate the range is unbounded on that side.
- "sheetId": 42, # The sheet this span is on.
- "endIndex": 42, # The end (exclusive) of the span, or not set if unbounded.
- "startIndex": 42, # The start (inclusive) of the span, or not set if unbounded.
- "dimension": "A String", # The dimension of the span.
- },
- },
- "metadataId": 42, # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.metadata_id.
- "visibility": "A String", # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.visibility. If left unspecified, all developer
- # metadata visibile to the requesting project is considered.
- "metadataValue": "A String", # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.metadata_value.
- "locationType": "A String", # Limits the selected developer metadata to those entries which are
- # associated with locations of the specified type. For example, when this
- # field is specified as ROW this lookup
- # only considers developer metadata associated on rows. If the field is left
- # unspecified, all location types are considered. This field cannot be
- # specified as SPREADSHEET when
- # the locationMatchingStrategy
- # is specified as INTERSECTING or when the
- # metadataLocation is specified as a
- # non-spreadsheet location: spreadsheet metadata cannot intersect any other
- # developer metadata location. This field also must be left unspecified when
- # the locationMatchingStrategy
- # is specified as EXACT.
- "locationMatchingStrategy": "A String", # Determines how this lookup matches the location. If this field is
- # specified as EXACT, only developer metadata associated on the exact
- # location specified is matched. If this field is specified to INTERSECTING,
- # developer metadata associated on intersecting locations is also
- # matched. If left unspecified, this field assumes a default value of
- # INTERSECTING.
- # If this field is specified, a metadataLocation
- # must also be specified.
- "metadataKey": "A String", # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.metadata_key.
- },
- "a1Range": "A String", # Selects data that matches the specified A1 range.
},
],
}
@@ -660,6 +660,68 @@
# values.
{ # Filter that describes what data should be selected or returned from a
# request.
+ "developerMetadataLookup": { # Selects DeveloperMetadata that matches all of the specified fields. For # Selects data associated with the developer metadata matching the criteria
+ # described by this DeveloperMetadataLookup.
+ # example, if only a metadata ID is specified this considers the
+ # DeveloperMetadata with that particular unique ID. If a metadata key is
+ # specified, this considers all developer metadata with that key. If a
+ # key, visibility, and location type are all specified, this considers all
+ # developer metadata with that key and visibility that are associated with a
+ # location of that type. In general, this
+ # selects all DeveloperMetadata that matches the intersection of all the
+ # specified fields; any field or combination of fields may be specified.
+ "locationType": "A String", # Limits the selected developer metadata to those entries which are
+ # associated with locations of the specified type. For example, when this
+ # field is specified as ROW this lookup
+ # only considers developer metadata associated on rows. If the field is left
+ # unspecified, all location types are considered. This field cannot be
+ # specified as SPREADSHEET when
+ # the locationMatchingStrategy
+ # is specified as INTERSECTING or when the
+ # metadataLocation is specified as a
+ # non-spreadsheet location: spreadsheet metadata cannot intersect any other
+ # developer metadata location. This field also must be left unspecified when
+ # the locationMatchingStrategy
+ # is specified as EXACT.
+ "metadataKey": "A String", # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_key.
+ "locationMatchingStrategy": "A String", # Determines how this lookup matches the location. If this field is
+ # specified as EXACT, only developer metadata associated on the exact
+ # location specified is matched. If this field is specified to INTERSECTING,
+ # developer metadata associated on intersecting locations is also
+ # matched. If left unspecified, this field assumes a default value of
+ # INTERSECTING.
+ # If this field is specified, a metadataLocation
+ # must also be specified.
+ "metadataLocation": { # A location where metadata may be associated in a spreadsheet. # Limits the selected developer metadata to those entries associated with
+ # the specified location. This field either matches exact locations or all
+ # intersecting locations according the specified
+ # locationMatchingStrategy.
+ "sheetId": 42, # The ID of the sheet when metadata is associated with an entire sheet.
+ "spreadsheet": True or False, # True when metadata is associated with an entire spreadsheet.
+ "locationType": "A String", # The type of location this object represents. This field is read-only.
+ "dimensionRange": { # A range along a single dimension on a sheet. # Represents the row or column when metadata is associated with
+ # a dimension. The specified DimensionRange must represent a single row
+ # or column; it cannot be unbounded or span multiple rows or columns.
+ # All indexes are zero-based.
+ # Indexes are half open: the start index is inclusive
+ # and the end index is exclusive.
+ # Missing indexes indicate the range is unbounded on that side.
+ "dimension": "A String", # The dimension of the span.
+ "sheetId": 42, # The sheet this span is on.
+ "endIndex": 42, # The end (exclusive) of the span, or not set if unbounded.
+ "startIndex": 42, # The start (inclusive) of the span, or not set if unbounded.
+ },
+ },
+ "metadataId": 42, # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_id.
+ "visibility": "A String", # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.visibility. If left unspecified, all developer
+ # metadata visibile to the requesting project is considered.
+ "metadataValue": "A String", # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_value.
+ },
+ "a1Range": "A String", # Selects data that matches the specified A1 range.
"gridRange": { # A range on a sheet. # Selects data that matches the range described by the GridRange.
# All indexes are zero-based.
# Indexes are half open, e.g the start index is inclusive
@@ -689,74 +751,12 @@
# If the start index equals the end index, then the range is empty.
# Empty ranges are typically not meaningful and are usually rendered in the
# UI as `#REF!`.
- "endRowIndex": 42, # The end row (exclusive) of the range, or not set if unbounded.
- "startColumnIndex": 42, # The start column (inclusive) of the range, or not set if unbounded.
"sheetId": 42, # The sheet this range is on.
"endColumnIndex": 42, # The end column (exclusive) of the range, or not set if unbounded.
"startRowIndex": 42, # The start row (inclusive) of the range, or not set if unbounded.
+ "endRowIndex": 42, # The end row (exclusive) of the range, or not set if unbounded.
+ "startColumnIndex": 42, # The start column (inclusive) of the range, or not set if unbounded.
},
- "developerMetadataLookup": { # Selects DeveloperMetadata that matches all of the specified fields. For # Selects data associated with the developer metadata matching the criteria
- # described by this DeveloperMetadataLookup.
- # example, if only a metadata ID is specified this considers the
- # DeveloperMetadata with that particular unique ID. If a metadata key is
- # specified, this considers all developer metadata with that key. If a
- # key, visibility, and location type are all specified, this considers all
- # developer metadata with that key and visibility that are associated with a
- # location of that type. In general, this
- # selects all DeveloperMetadata that matches the intersection of all the
- # specified fields; any field or combination of fields may be specified.
- "metadataLocation": { # A location where metadata may be associated in a spreadsheet. # Limits the selected developer metadata to those entries associated with
- # the specified location. This field either matches exact locations or all
- # intersecting locations according the specified
- # locationMatchingStrategy.
- "sheetId": 42, # The ID of the sheet when metadata is associated with an entire sheet.
- "spreadsheet": True or False, # True when metadata is associated with an entire spreadsheet.
- "locationType": "A String", # The type of location this object represents. This field is read-only.
- "dimensionRange": { # A range along a single dimension on a sheet. # Represents the row or column when metadata is associated with
- # a dimension. The specified DimensionRange must represent a single row
- # or column; it cannot be unbounded or span multiple rows or columns.
- # All indexes are zero-based.
- # Indexes are half open: the start index is inclusive
- # and the end index is exclusive.
- # Missing indexes indicate the range is unbounded on that side.
- "sheetId": 42, # The sheet this span is on.
- "endIndex": 42, # The end (exclusive) of the span, or not set if unbounded.
- "startIndex": 42, # The start (inclusive) of the span, or not set if unbounded.
- "dimension": "A String", # The dimension of the span.
- },
- },
- "metadataId": 42, # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.metadata_id.
- "visibility": "A String", # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.visibility. If left unspecified, all developer
- # metadata visibile to the requesting project is considered.
- "metadataValue": "A String", # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.metadata_value.
- "locationType": "A String", # Limits the selected developer metadata to those entries which are
- # associated with locations of the specified type. For example, when this
- # field is specified as ROW this lookup
- # only considers developer metadata associated on rows. If the field is left
- # unspecified, all location types are considered. This field cannot be
- # specified as SPREADSHEET when
- # the locationMatchingStrategy
- # is specified as INTERSECTING or when the
- # metadataLocation is specified as a
- # non-spreadsheet location: spreadsheet metadata cannot intersect any other
- # developer metadata location. This field also must be left unspecified when
- # the locationMatchingStrategy
- # is specified as EXACT.
- "locationMatchingStrategy": "A String", # Determines how this lookup matches the location. If this field is
- # specified as EXACT, only developer metadata associated on the exact
- # location specified is matched. If this field is specified to INTERSECTING,
- # developer metadata associated on intersecting locations is also
- # matched. If left unspecified, this field assumes a default value of
- # INTERSECTING.
- # If this field is specified, a metadataLocation
- # must also be specified.
- "metadataKey": "A String", # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.metadata_key.
- },
- "a1Range": "A String", # Selects data that matches the specified A1 range.
},
],
},
@@ -839,6 +839,7 @@
An object of the form:
{ # The response when updating a range of values in a spreadsheet.
+ "spreadsheetId": "A String", # The spreadsheet the updates were applied to.
"totalUpdatedColumns": 42, # The total number of columns where at least one cell in the column was
# updated.
"totalUpdatedRows": 42, # The total number of rows where at least one cell in the row was updated.
@@ -848,6 +849,11 @@
"responses": [ # One UpdateValuesResponse per requested range, in the same order as
# the requests appeared.
{ # The response when updating a range of values in a spreadsheet.
+ "updatedRows": 42, # The number of rows where at least one cell in the row was updated.
+ "updatedRange": "A String", # The range (in A1 notation) that updates were applied to.
+ "updatedCells": 42, # The number of cells updated.
+ "updatedColumns": 42, # The number of columns where at least one cell in the column was updated.
+ "spreadsheetId": "A String", # The spreadsheet the updates were applied to.
"updatedData": { # Data within a range of the spreadsheet. # The values of the cells after updates were applied.
# This is only included if the request's `includeValuesInResponse` field
# was `true`.
@@ -884,14 +890,8 @@
#
# When writing, if this field is not set, it defaults to ROWS.
},
- "updatedRows": 42, # The number of rows where at least one cell in the row was updated.
- "updatedRange": "A String", # The range (in A1 notation) that updates were applied to.
- "updatedCells": 42, # The number of cells updated.
- "updatedColumns": 42, # The number of columns where at least one cell in the column was updated.
- "spreadsheetId": "A String", # The spreadsheet the updates were applied to.
},
],
- "spreadsheetId": "A String", # The spreadsheet the updates were applied to.
}</pre>
</div>
@@ -908,6 +908,8 @@
The object takes the form of:
{ # The request for updating more than one range of values in a spreadsheet.
+ "responseValueRenderOption": "A String", # Determines how values in the response should be rendered.
+ # The default render option is ValueRenderOption.FORMATTED_VALUE.
"responseDateTimeRenderOption": "A String", # Determines how dates, times, and durations in the response should be
# rendered. This is ignored if response_value_render_option is
# FORMATTED_VALUE.
@@ -921,6 +923,68 @@
"majorDimension": "A String", # The major dimension of the values.
"dataFilter": { # Filter that describes what data should be selected or returned from a # The data filter describing the location of the values in the spreadsheet.
# request.
+ "developerMetadataLookup": { # Selects DeveloperMetadata that matches all of the specified fields. For # Selects data associated with the developer metadata matching the criteria
+ # described by this DeveloperMetadataLookup.
+ # example, if only a metadata ID is specified this considers the
+ # DeveloperMetadata with that particular unique ID. If a metadata key is
+ # specified, this considers all developer metadata with that key. If a
+ # key, visibility, and location type are all specified, this considers all
+ # developer metadata with that key and visibility that are associated with a
+ # location of that type. In general, this
+ # selects all DeveloperMetadata that matches the intersection of all the
+ # specified fields; any field or combination of fields may be specified.
+ "locationType": "A String", # Limits the selected developer metadata to those entries which are
+ # associated with locations of the specified type. For example, when this
+ # field is specified as ROW this lookup
+ # only considers developer metadata associated on rows. If the field is left
+ # unspecified, all location types are considered. This field cannot be
+ # specified as SPREADSHEET when
+ # the locationMatchingStrategy
+ # is specified as INTERSECTING or when the
+ # metadataLocation is specified as a
+ # non-spreadsheet location: spreadsheet metadata cannot intersect any other
+ # developer metadata location. This field also must be left unspecified when
+ # the locationMatchingStrategy
+ # is specified as EXACT.
+ "metadataKey": "A String", # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_key.
+ "locationMatchingStrategy": "A String", # Determines how this lookup matches the location. If this field is
+ # specified as EXACT, only developer metadata associated on the exact
+ # location specified is matched. If this field is specified to INTERSECTING,
+ # developer metadata associated on intersecting locations is also
+ # matched. If left unspecified, this field assumes a default value of
+ # INTERSECTING.
+ # If this field is specified, a metadataLocation
+ # must also be specified.
+ "metadataLocation": { # A location where metadata may be associated in a spreadsheet. # Limits the selected developer metadata to those entries associated with
+ # the specified location. This field either matches exact locations or all
+ # intersecting locations according the specified
+ # locationMatchingStrategy.
+ "sheetId": 42, # The ID of the sheet when metadata is associated with an entire sheet.
+ "spreadsheet": True or False, # True when metadata is associated with an entire spreadsheet.
+ "locationType": "A String", # The type of location this object represents. This field is read-only.
+ "dimensionRange": { # A range along a single dimension on a sheet. # Represents the row or column when metadata is associated with
+ # a dimension. The specified DimensionRange must represent a single row
+ # or column; it cannot be unbounded or span multiple rows or columns.
+ # All indexes are zero-based.
+ # Indexes are half open: the start index is inclusive
+ # and the end index is exclusive.
+ # Missing indexes indicate the range is unbounded on that side.
+ "dimension": "A String", # The dimension of the span.
+ "sheetId": 42, # The sheet this span is on.
+ "endIndex": 42, # The end (exclusive) of the span, or not set if unbounded.
+ "startIndex": 42, # The start (inclusive) of the span, or not set if unbounded.
+ },
+ },
+ "metadataId": 42, # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_id.
+ "visibility": "A String", # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.visibility. If left unspecified, all developer
+ # metadata visibile to the requesting project is considered.
+ "metadataValue": "A String", # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_value.
+ },
+ "a1Range": "A String", # Selects data that matches the specified A1 range.
"gridRange": { # A range on a sheet. # Selects data that matches the range described by the GridRange.
# All indexes are zero-based.
# Indexes are half open, e.g the start index is inclusive
@@ -950,74 +1014,12 @@
# If the start index equals the end index, then the range is empty.
# Empty ranges are typically not meaningful and are usually rendered in the
# UI as `#REF!`.
- "endRowIndex": 42, # The end row (exclusive) of the range, or not set if unbounded.
- "startColumnIndex": 42, # The start column (inclusive) of the range, or not set if unbounded.
"sheetId": 42, # The sheet this range is on.
"endColumnIndex": 42, # The end column (exclusive) of the range, or not set if unbounded.
"startRowIndex": 42, # The start row (inclusive) of the range, or not set if unbounded.
+ "endRowIndex": 42, # The end row (exclusive) of the range, or not set if unbounded.
+ "startColumnIndex": 42, # The start column (inclusive) of the range, or not set if unbounded.
},
- "developerMetadataLookup": { # Selects DeveloperMetadata that matches all of the specified fields. For # Selects data associated with the developer metadata matching the criteria
- # described by this DeveloperMetadataLookup.
- # example, if only a metadata ID is specified this considers the
- # DeveloperMetadata with that particular unique ID. If a metadata key is
- # specified, this considers all developer metadata with that key. If a
- # key, visibility, and location type are all specified, this considers all
- # developer metadata with that key and visibility that are associated with a
- # location of that type. In general, this
- # selects all DeveloperMetadata that matches the intersection of all the
- # specified fields; any field or combination of fields may be specified.
- "metadataLocation": { # A location where metadata may be associated in a spreadsheet. # Limits the selected developer metadata to those entries associated with
- # the specified location. This field either matches exact locations or all
- # intersecting locations according the specified
- # locationMatchingStrategy.
- "sheetId": 42, # The ID of the sheet when metadata is associated with an entire sheet.
- "spreadsheet": True or False, # True when metadata is associated with an entire spreadsheet.
- "locationType": "A String", # The type of location this object represents. This field is read-only.
- "dimensionRange": { # A range along a single dimension on a sheet. # Represents the row or column when metadata is associated with
- # a dimension. The specified DimensionRange must represent a single row
- # or column; it cannot be unbounded or span multiple rows or columns.
- # All indexes are zero-based.
- # Indexes are half open: the start index is inclusive
- # and the end index is exclusive.
- # Missing indexes indicate the range is unbounded on that side.
- "sheetId": 42, # The sheet this span is on.
- "endIndex": 42, # The end (exclusive) of the span, or not set if unbounded.
- "startIndex": 42, # The start (inclusive) of the span, or not set if unbounded.
- "dimension": "A String", # The dimension of the span.
- },
- },
- "metadataId": 42, # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.metadata_id.
- "visibility": "A String", # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.visibility. If left unspecified, all developer
- # metadata visibile to the requesting project is considered.
- "metadataValue": "A String", # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.metadata_value.
- "locationType": "A String", # Limits the selected developer metadata to those entries which are
- # associated with locations of the specified type. For example, when this
- # field is specified as ROW this lookup
- # only considers developer metadata associated on rows. If the field is left
- # unspecified, all location types are considered. This field cannot be
- # specified as SPREADSHEET when
- # the locationMatchingStrategy
- # is specified as INTERSECTING or when the
- # metadataLocation is specified as a
- # non-spreadsheet location: spreadsheet metadata cannot intersect any other
- # developer metadata location. This field also must be left unspecified when
- # the locationMatchingStrategy
- # is specified as EXACT.
- "locationMatchingStrategy": "A String", # Determines how this lookup matches the location. If this field is
- # specified as EXACT, only developer metadata associated on the exact
- # location specified is matched. If this field is specified to INTERSECTING,
- # developer metadata associated on intersecting locations is also
- # matched. If left unspecified, this field assumes a default value of
- # INTERSECTING.
- # If this field is specified, a metadataLocation
- # must also be specified.
- "metadataKey": "A String", # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.metadata_key.
- },
- "a1Range": "A String", # Selects data that matches the specified A1 range.
},
"values": [ # The data to be written. If the provided values exceed any of the ranges
# matched by the data filter then the request fails. If the provided values
@@ -1036,8 +1038,6 @@
# values. If the range to write was larger than the range actually written,
# the response includes all values in the requested range (excluding trailing
# empty rows and columns).
- "responseValueRenderOption": "A String", # Determines how values in the response should be rendered.
- # The default render option is ValueRenderOption.FORMATTED_VALUE.
}
x__xgafv: string, V1 error format.
@@ -1059,6 +1059,7 @@
"responses": [ # The response for each range updated.
{ # The response when updating a range of values by a data filter in a
# spreadsheet.
+ "updatedColumns": 42, # The number of columns where at least one cell in the column was updated.
"updatedData": { # Data within a range of the spreadsheet. # The values of the cells in the range matched by the dataFilter after all
# updates were applied. This is only included if the request's
# `includeValuesInResponse` field was `true`.
@@ -1097,6 +1098,68 @@
},
"dataFilter": { # Filter that describes what data should be selected or returned from a # The data filter that selected the range that was updated.
# request.
+ "developerMetadataLookup": { # Selects DeveloperMetadata that matches all of the specified fields. For # Selects data associated with the developer metadata matching the criteria
+ # described by this DeveloperMetadataLookup.
+ # example, if only a metadata ID is specified this considers the
+ # DeveloperMetadata with that particular unique ID. If a metadata key is
+ # specified, this considers all developer metadata with that key. If a
+ # key, visibility, and location type are all specified, this considers all
+ # developer metadata with that key and visibility that are associated with a
+ # location of that type. In general, this
+ # selects all DeveloperMetadata that matches the intersection of all the
+ # specified fields; any field or combination of fields may be specified.
+ "locationType": "A String", # Limits the selected developer metadata to those entries which are
+ # associated with locations of the specified type. For example, when this
+ # field is specified as ROW this lookup
+ # only considers developer metadata associated on rows. If the field is left
+ # unspecified, all location types are considered. This field cannot be
+ # specified as SPREADSHEET when
+ # the locationMatchingStrategy
+ # is specified as INTERSECTING or when the
+ # metadataLocation is specified as a
+ # non-spreadsheet location: spreadsheet metadata cannot intersect any other
+ # developer metadata location. This field also must be left unspecified when
+ # the locationMatchingStrategy
+ # is specified as EXACT.
+ "metadataKey": "A String", # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_key.
+ "locationMatchingStrategy": "A String", # Determines how this lookup matches the location. If this field is
+ # specified as EXACT, only developer metadata associated on the exact
+ # location specified is matched. If this field is specified to INTERSECTING,
+ # developer metadata associated on intersecting locations is also
+ # matched. If left unspecified, this field assumes a default value of
+ # INTERSECTING.
+ # If this field is specified, a metadataLocation
+ # must also be specified.
+ "metadataLocation": { # A location where metadata may be associated in a spreadsheet. # Limits the selected developer metadata to those entries associated with
+ # the specified location. This field either matches exact locations or all
+ # intersecting locations according the specified
+ # locationMatchingStrategy.
+ "sheetId": 42, # The ID of the sheet when metadata is associated with an entire sheet.
+ "spreadsheet": True or False, # True when metadata is associated with an entire spreadsheet.
+ "locationType": "A String", # The type of location this object represents. This field is read-only.
+ "dimensionRange": { # A range along a single dimension on a sheet. # Represents the row or column when metadata is associated with
+ # a dimension. The specified DimensionRange must represent a single row
+ # or column; it cannot be unbounded or span multiple rows or columns.
+ # All indexes are zero-based.
+ # Indexes are half open: the start index is inclusive
+ # and the end index is exclusive.
+ # Missing indexes indicate the range is unbounded on that side.
+ "dimension": "A String", # The dimension of the span.
+ "sheetId": 42, # The sheet this span is on.
+ "endIndex": 42, # The end (exclusive) of the span, or not set if unbounded.
+ "startIndex": 42, # The start (inclusive) of the span, or not set if unbounded.
+ },
+ },
+ "metadataId": 42, # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_id.
+ "visibility": "A String", # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.visibility. If left unspecified, all developer
+ # metadata visibile to the requesting project is considered.
+ "metadataValue": "A String", # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_value.
+ },
+ "a1Range": "A String", # Selects data that matches the specified A1 range.
"gridRange": { # A range on a sheet. # Selects data that matches the range described by the GridRange.
# All indexes are zero-based.
# Indexes are half open, e.g the start index is inclusive
@@ -1126,79 +1189,16 @@
# If the start index equals the end index, then the range is empty.
# Empty ranges are typically not meaningful and are usually rendered in the
# UI as `#REF!`.
- "endRowIndex": 42, # The end row (exclusive) of the range, or not set if unbounded.
- "startColumnIndex": 42, # The start column (inclusive) of the range, or not set if unbounded.
"sheetId": 42, # The sheet this range is on.
"endColumnIndex": 42, # The end column (exclusive) of the range, or not set if unbounded.
"startRowIndex": 42, # The start row (inclusive) of the range, or not set if unbounded.
+ "endRowIndex": 42, # The end row (exclusive) of the range, or not set if unbounded.
+ "startColumnIndex": 42, # The start column (inclusive) of the range, or not set if unbounded.
},
- "developerMetadataLookup": { # Selects DeveloperMetadata that matches all of the specified fields. For # Selects data associated with the developer metadata matching the criteria
- # described by this DeveloperMetadataLookup.
- # example, if only a metadata ID is specified this considers the
- # DeveloperMetadata with that particular unique ID. If a metadata key is
- # specified, this considers all developer metadata with that key. If a
- # key, visibility, and location type are all specified, this considers all
- # developer metadata with that key and visibility that are associated with a
- # location of that type. In general, this
- # selects all DeveloperMetadata that matches the intersection of all the
- # specified fields; any field or combination of fields may be specified.
- "metadataLocation": { # A location where metadata may be associated in a spreadsheet. # Limits the selected developer metadata to those entries associated with
- # the specified location. This field either matches exact locations or all
- # intersecting locations according the specified
- # locationMatchingStrategy.
- "sheetId": 42, # The ID of the sheet when metadata is associated with an entire sheet.
- "spreadsheet": True or False, # True when metadata is associated with an entire spreadsheet.
- "locationType": "A String", # The type of location this object represents. This field is read-only.
- "dimensionRange": { # A range along a single dimension on a sheet. # Represents the row or column when metadata is associated with
- # a dimension. The specified DimensionRange must represent a single row
- # or column; it cannot be unbounded or span multiple rows or columns.
- # All indexes are zero-based.
- # Indexes are half open: the start index is inclusive
- # and the end index is exclusive.
- # Missing indexes indicate the range is unbounded on that side.
- "sheetId": 42, # The sheet this span is on.
- "endIndex": 42, # The end (exclusive) of the span, or not set if unbounded.
- "startIndex": 42, # The start (inclusive) of the span, or not set if unbounded.
- "dimension": "A String", # The dimension of the span.
- },
- },
- "metadataId": 42, # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.metadata_id.
- "visibility": "A String", # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.visibility. If left unspecified, all developer
- # metadata visibile to the requesting project is considered.
- "metadataValue": "A String", # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.metadata_value.
- "locationType": "A String", # Limits the selected developer metadata to those entries which are
- # associated with locations of the specified type. For example, when this
- # field is specified as ROW this lookup
- # only considers developer metadata associated on rows. If the field is left
- # unspecified, all location types are considered. This field cannot be
- # specified as SPREADSHEET when
- # the locationMatchingStrategy
- # is specified as INTERSECTING or when the
- # metadataLocation is specified as a
- # non-spreadsheet location: spreadsheet metadata cannot intersect any other
- # developer metadata location. This field also must be left unspecified when
- # the locationMatchingStrategy
- # is specified as EXACT.
- "locationMatchingStrategy": "A String", # Determines how this lookup matches the location. If this field is
- # specified as EXACT, only developer metadata associated on the exact
- # location specified is matched. If this field is specified to INTERSECTING,
- # developer metadata associated on intersecting locations is also
- # matched. If left unspecified, this field assumes a default value of
- # INTERSECTING.
- # If this field is specified, a metadataLocation
- # must also be specified.
- "metadataKey": "A String", # Limits the selected developer metadata to that which has a matching
- # DeveloperMetadata.metadata_key.
- },
- "a1Range": "A String", # Selects data that matches the specified A1 range.
},
"updatedRows": 42, # The number of rows where at least one cell in the row was updated.
"updatedRange": "A String", # The range (in A1 notation) that updates were applied to.
"updatedCells": 42, # The number of cells updated.
- "updatedColumns": 42, # The number of columns where at least one cell in the column was updated.
},
],
}</pre>
@@ -1302,7 +1302,7 @@
</div>
<div class="method">
- <code class="details" id="update">update(spreadsheetId, range, body=None, responseDateTimeRenderOption=None, valueInputOption=None, includeValuesInResponse=None, responseValueRenderOption=None, x__xgafv=None)</code>
+ <code class="details" id="update">update(spreadsheetId, range, body=None, responseValueRenderOption=None, responseDateTimeRenderOption=None, valueInputOption=None, includeValuesInResponse=None, x__xgafv=None)</code>
<pre>Sets values in a range of a spreadsheet.
The caller must specify the spreadsheet ID, range, and
a valueInputOption.
@@ -1348,6 +1348,8 @@
# When writing, if this field is not set, it defaults to ROWS.
}
+ responseValueRenderOption: string, Determines how values in the response should be rendered.
+The default render option is ValueRenderOption.FORMATTED_VALUE.
responseDateTimeRenderOption: string, Determines how dates, times, and durations in the response should be
rendered. This is ignored if response_value_render_option is
FORMATTED_VALUE.
@@ -1360,8 +1362,6 @@
If the range to write was larger than the range actually written, the
response includes all values in the requested range (excluding trailing
empty rows and columns).
- responseValueRenderOption: string, Determines how values in the response should be rendered.
-The default render option is ValueRenderOption.FORMATTED_VALUE.
x__xgafv: string, V1 error format.
Allowed values
1 - v1 error format
@@ -1371,6 +1371,11 @@
An object of the form:
{ # The response when updating a range of values in a spreadsheet.
+ "updatedRows": 42, # The number of rows where at least one cell in the row was updated.
+ "updatedRange": "A String", # The range (in A1 notation) that updates were applied to.
+ "updatedCells": 42, # The number of cells updated.
+ "updatedColumns": 42, # The number of columns where at least one cell in the column was updated.
+ "spreadsheetId": "A String", # The spreadsheet the updates were applied to.
"updatedData": { # Data within a range of the spreadsheet. # The values of the cells after updates were applied.
# This is only included if the request's `includeValuesInResponse` field
# was `true`.
@@ -1407,11 +1412,6 @@
#
# When writing, if this field is not set, it defaults to ROWS.
},
- "updatedRows": 42, # The number of rows where at least one cell in the row was updated.
- "updatedRange": "A String", # The range (in A1 notation) that updates were applied to.
- "updatedCells": 42, # The number of cells updated.
- "updatedColumns": 42, # The number of columns where at least one cell in the column was updated.
- "spreadsheetId": "A String", # The spreadsheet the updates were applied to.
}</pre>
</div>