docs: update generated docs (#981)
diff --git a/docs/dyn/sheets_v4.spreadsheets.values.html b/docs/dyn/sheets_v4.spreadsheets.values.html
index 37e867d..9596c7f 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, valueInputOption=None, includeValuesInResponse=None, insertDataOption=None, responseValueRenderOption=None, responseDateTimeRenderOption=None, x__xgafv=None)</a></code></p>
+ <code><a href="#append">append(spreadsheetId, range, body=None, responseValueRenderOption=None, responseDateTimeRenderOption=None, insertDataOption=None, valueInputOption=None, includeValuesInResponse=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>
@@ -84,7 +84,7 @@
<code><a href="#batchClearByDataFilter">batchClearByDataFilter(spreadsheetId, body=None, x__xgafv=None)</a></code></p>
<p class="firstline">Clears one or more ranges of values from a spreadsheet.</p>
<p class="toc_element">
- <code><a href="#batchGet">batchGet(spreadsheetId, ranges=None, dateTimeRenderOption=None, majorDimension=None, valueRenderOption=None, x__xgafv=None)</a></code></p>
+ <code><a href="#batchGet">batchGet(spreadsheetId, valueRenderOption=None, majorDimension=None, ranges=None, dateTimeRenderOption=None, x__xgafv=None)</a></code></p>
<p class="firstline">Returns one or more ranges of values from a spreadsheet.</p>
<p class="toc_element">
<code><a href="#batchGetByDataFilter">batchGetByDataFilter(spreadsheetId, body=None, x__xgafv=None)</a></code></p>
@@ -99,14 +99,14 @@
<code><a href="#clear">clear(spreadsheetId, range, body=None, x__xgafv=None)</a></code></p>
<p class="firstline">Clears values from a spreadsheet.</p>
<p class="toc_element">
- <code><a href="#get">get(spreadsheetId, range, dateTimeRenderOption=None, majorDimension=None, valueRenderOption=None, x__xgafv=None)</a></code></p>
+ <code><a href="#get">get(spreadsheetId, range, dateTimeRenderOption=None, valueRenderOption=None, majorDimension=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, responseValueRenderOption=None, responseDateTimeRenderOption=None, valueInputOption=None, includeValuesInResponse=None, x__xgafv=None)</a></code></p>
+ <code><a href="#update">update(spreadsheetId, range, body=None, responseValueRenderOption=None, responseDateTimeRenderOption=None, includeValuesInResponse=None, valueInputOption=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, valueInputOption=None, includeValuesInResponse=None, insertDataOption=None, responseValueRenderOption=None, responseDateTimeRenderOption=None, x__xgafv=None)</code>
+ <code class="details" id="append">append(spreadsheetId, range, body=None, responseValueRenderOption=None, responseDateTimeRenderOption=None, insertDataOption=None, valueInputOption=None, includeValuesInResponse=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
@@ -144,11 +144,6 @@
"",
],
],
- "range": "A String", # The range the values cover, in A1 notation.
- # For output, this range indicates the entire requested range,
- # even though the values will exclude trailing rows and columns.
- # When appending values, this field represents the range to search for a
- # table, after which values will be appended.
"majorDimension": "A String", # The major dimension of the values.
#
# For output, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`,
@@ -162,19 +157,24 @@
# then `[[1,2],[3,4]]` will set `A1=1,B1=3,A2=2,B2=4`.
#
# When writing, if this field is not set, it defaults to ROWS.
+ "range": "A String", # The range the values cover, in A1 notation.
+ # For output, this range indicates the entire requested range,
+ # even though the values will exclude trailing rows and columns.
+ # When appending values, this field represents the range to search for a
+ # table, after which values will be appended.
}
- 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].
+ insertDataOption: string, How the input data should be inserted.
+ 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.
x__xgafv: string, V1 error format.
Allowed values
1 - v1 error format
@@ -184,15 +184,12 @@
An object of the form:
{ # The response when updating a range of values in a spreadsheet.
- "tableRange": "A String", # The range (in A1 notation) of the table that values are being appended to
- # (before the values were appended).
- # 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.
+ "updatedColumns": 42, # The number of columns where at least one cell in the column 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
@@ -211,11 +208,6 @@
"",
],
],
- "range": "A String", # The range the values cover, in A1 notation.
- # For output, this range indicates the entire requested range,
- # even though the values will exclude trailing rows and columns.
- # When appending values, this field represents the range to search for a
- # table, after which values will be appended.
"majorDimension": "A String", # The major dimension of the values.
#
# For output, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`,
@@ -229,8 +221,16 @@
# then `[[1,2],[3,4]]` will set `A1=1,B1=3,A2=2,B2=4`.
#
# When writing, if this field is not set, it defaults to ROWS.
+ "range": "A String", # The range the values cover, in A1 notation.
+ # For output, this range indicates the entire requested range,
+ # even though the values will exclude trailing rows and columns.
+ # When appending values, this field represents the range to search for a
+ # table, after which values will be appended.
},
},
+ "tableRange": "A String", # The range (in A1 notation) of the table that values are being appended to
+ # (before the values were appended).
+ # Empty if no table was found.
}</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>
@@ -298,6 +298,19 @@
# 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.
+ "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.
+ "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
@@ -311,21 +324,12 @@
# 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.
+ "metadataId": 42, # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_id.
"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
@@ -336,23 +340,18 @@
# 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.
+ "endIndex": 42, # The end (exclusive) of the span, or not set if unbounded.
+ "sheetId": 42, # The sheet this span is on.
},
+ "sheetId": 42, # The ID of the sheet when metadata is associated with an entire sheet.
},
- "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.
+ "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.
"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
+ # Indexes are half open, i.e. the start index is inclusive
# and the end index is exclusive -- [start_index, end_index).
# Missing indexes indicate the range is unbounded on that side.
#
@@ -379,12 +378,13 @@
# 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!`.
- "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.
+ "endRowIndex": 42, # The end row (exclusive) of the range, or not set if unbounded.
+ "sheetId": 42, # The sheet this range is on.
+ "startRowIndex": 42, # The start row (inclusive) of the range, or not set if unbounded.
},
+ "a1Range": "A String", # Selects data that matches the specified A1 range.
},
],
}
@@ -399,35 +399,35 @@
{ # The response when clearing a range of values selected with
# DataFilters 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>
<div class="method">
- <code class="details" id="batchGet">batchGet(spreadsheetId, ranges=None, dateTimeRenderOption=None, majorDimension=None, valueRenderOption=None, x__xgafv=None)</code>
+ <code class="details" id="batchGet">batchGet(spreadsheetId, valueRenderOption=None, majorDimension=None, ranges=None, dateTimeRenderOption=None, x__xgafv=None)</code>
<pre>Returns one or more ranges of values from a spreadsheet.
The caller must specify the spreadsheet ID and one or more ranges.
Args:
spreadsheetId: string, The ID of the spreadsheet to retrieve data from. (required)
- ranges: string, The A1 notation of the values to retrieve. (repeated)
- dateTimeRenderOption: string, How dates, times, and durations should be represented in the output.
-This is ignored if value_render_option is
-FORMATTED_VALUE.
-The default dateTime render option is [DateTimeRenderOption.SERIAL_NUMBER].
+ valueRenderOption: string, How values should be represented in the output.
+The default render option is ValueRenderOption.FORMATTED_VALUE.
majorDimension: string, The major dimension that results should use.
For example, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`,
then requesting `range=A1:B2,majorDimension=ROWS` returns `[[1,2],[3,4]]`,
whereas requesting `range=A1:B2,majorDimension=COLUMNS` returns
`[[1,3],[2,4]]`.
- valueRenderOption: string, How values should be represented in the output.
-The default render option is ValueRenderOption.FORMATTED_VALUE.
+ ranges: string, The A1 notation of the values to retrieve. (repeated)
+ dateTimeRenderOption: string, How dates, times, and durations should be represented in the output.
+This is ignored if value_render_option is
+FORMATTED_VALUE.
+The default dateTime render option is [DateTimeRenderOption.SERIAL_NUMBER].
x__xgafv: string, V1 error format.
Allowed values
1 - v1 error format
@@ -437,7 +437,6 @@
An object of the form:
{ # The response when retrieving more than one range of values in a spreadsheet.
- "spreadsheetId": "A String", # The ID of the spreadsheet the data was retrieved from.
"valueRanges": [ # The requested values. The order of the ValueRanges is the same as the
# order of the requested ranges.
{ # Data within a range of the spreadsheet.
@@ -455,11 +454,6 @@
"",
],
],
- "range": "A String", # The range the values cover, in A1 notation.
- # For output, this range indicates the entire requested range,
- # even though the values will exclude trailing rows and columns.
- # When appending values, this field represents the range to search for a
- # table, after which values will be appended.
"majorDimension": "A String", # The major dimension of the values.
#
# For output, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`,
@@ -473,8 +467,14 @@
# then `[[1,2],[3,4]]` will set `A1=1,B1=3,A2=2,B2=4`.
#
# When writing, if this field is not set, it defaults to ROWS.
+ "range": "A String", # The range the values cover, in A1 notation.
+ # For output, this range indicates the entire requested range,
+ # even though the values will exclude trailing rows and columns.
+ # When appending values, this field represents the range to search for a
+ # table, after which values will be appended.
},
],
+ "spreadsheetId": "A String", # The ID of the spreadsheet the data was retrieved from.
}</pre>
</div>
@@ -496,14 +496,14 @@
# This is ignored if value_render_option is
# FORMATTED_VALUE.
# The default dateTime render option is [DateTimeRenderOption.SERIAL_NUMBER].
+ "valueRenderOption": "A String", # How values should be represented in the output.
+ # The default render option is ValueRenderOption.FORMATTED_VALUE.
"majorDimension": "A String", # The major dimension that results should use.
#
# For example, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`,
# then a request that selects that range and sets `majorDimension=ROWS`
# returns `[[1,2],[3,4]]`, whereas a request that sets
# `majorDimension=COLUMNS` returns `[[1,3],[2,4]]`.
- "valueRenderOption": "A String", # How values should be represented in the output.
- # The default render option is ValueRenderOption.FORMATTED_VALUE.
"dataFilters": [ # The data filters used to match the ranges of values to retrieve. Ranges
# 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
@@ -518,6 +518,19 @@
# 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.
+ "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.
+ "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
@@ -531,21 +544,12 @@
# 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.
+ "metadataId": 42, # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_id.
"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
@@ -556,23 +560,18 @@
# 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.
+ "endIndex": 42, # The end (exclusive) of the span, or not set if unbounded.
+ "sheetId": 42, # The sheet this span is on.
},
+ "sheetId": 42, # The ID of the sheet when metadata is associated with an entire sheet.
},
- "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.
+ "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.
"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
+ # Indexes are half open, i.e. the start index is inclusive
# and the end index is exclusive -- [start_index, end_index).
# Missing indexes indicate the range is unbounded on that side.
#
@@ -599,12 +598,13 @@
# 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!`.
- "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.
+ "endRowIndex": 42, # The end row (exclusive) of the range, or not set if unbounded.
+ "sheetId": 42, # The sheet this range is on.
+ "startRowIndex": 42, # The start row (inclusive) of the range, or not set if unbounded.
},
+ "a1Range": "A String", # Selects data that matches the specified A1 range.
},
],
}
@@ -622,40 +622,6 @@
"spreadsheetId": "A String", # The ID of the spreadsheet the data was retrieved from.
"valueRanges": [ # The requested values with the list of data filters that matched them.
{ # A value range that was matched by one or more data filers.
- "valueRange": { # Data within a range of the spreadsheet. # The values matched by the DataFilter.
- "values": [ # The data that was read or to be written. This is an array of arrays,
- # the outer array representing all the data and each inner array
- # representing a major dimension. Each item in the inner array
- # corresponds with one cell.
- #
- # For output, empty trailing rows and columns will not be included.
- #
- # For input, supported value types are: bool, string, and double.
- # Null values will be skipped.
- # To set a cell to an empty value, set the string value to an empty string.
- [
- "",
- ],
- ],
- "range": "A String", # The range the values cover, in A1 notation.
- # For output, this range indicates the entire requested range,
- # even though the values will exclude trailing rows and columns.
- # When appending values, this field represents the range to search for a
- # table, after which values will be appended.
- "majorDimension": "A String", # The major dimension of the values.
- #
- # For output, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`,
- # then requesting `range=A1:B2,majorDimension=ROWS` will return
- # `[[1,2],[3,4]]`,
- # whereas requesting `range=A1:B2,majorDimension=COLUMNS` will return
- # `[[1,3],[2,4]]`.
- #
- # For input, with `range=A1:B2,majorDimension=ROWS` then `[[1,2],[3,4]]`
- # will set `A1=1,B1=2,A2=3,B2=4`. With `range=A1:B2,majorDimension=COLUMNS`
- # then `[[1,2],[3,4]]` will set `A1=1,B1=3,A2=2,B2=4`.
- #
- # When writing, if this field is not set, it defaults to ROWS.
- },
"dataFilters": [ # The DataFilters from the request that matched the range of
# values.
{ # Filter that describes what data should be selected or returned from a
@@ -670,6 +636,19 @@
# 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.
+ "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.
+ "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
@@ -683,21 +662,12 @@
# 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.
+ "metadataId": 42, # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_id.
"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
@@ -708,23 +678,18 @@
# 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.
+ "endIndex": 42, # The end (exclusive) of the span, or not set if unbounded.
+ "sheetId": 42, # The sheet this span is on.
},
+ "sheetId": 42, # The ID of the sheet when metadata is associated with an entire sheet.
},
- "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.
+ "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.
"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
+ # Indexes are half open, i.e. the start index is inclusive
# and the end index is exclusive -- [start_index, end_index).
# Missing indexes indicate the range is unbounded on that side.
#
@@ -751,14 +716,49 @@
# 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!`.
- "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.
+ "endRowIndex": 42, # The end row (exclusive) of the range, or not set if unbounded.
+ "sheetId": 42, # The sheet this range is on.
+ "startRowIndex": 42, # The start row (inclusive) of the range, or not set if unbounded.
},
+ "a1Range": "A String", # Selects data that matches the specified A1 range.
},
],
+ "valueRange": { # Data within a range of the spreadsheet. # The values matched by the DataFilter.
+ "values": [ # The data that was read or to be written. This is an array of arrays,
+ # the outer array representing all the data and each inner array
+ # representing a major dimension. Each item in the inner array
+ # corresponds with one cell.
+ #
+ # For output, empty trailing rows and columns will not be included.
+ #
+ # For input, supported value types are: bool, string, and double.
+ # Null values will be skipped.
+ # To set a cell to an empty value, set the string value to an empty string.
+ [
+ "",
+ ],
+ ],
+ "majorDimension": "A String", # The major dimension of the values.
+ #
+ # For output, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`,
+ # then requesting `range=A1:B2,majorDimension=ROWS` will return
+ # `[[1,2],[3,4]]`,
+ # whereas requesting `range=A1:B2,majorDimension=COLUMNS` will return
+ # `[[1,3],[2,4]]`.
+ #
+ # For input, with `range=A1:B2,majorDimension=ROWS` then `[[1,2],[3,4]]`
+ # will set `A1=1,B1=2,A2=3,B2=4`. With `range=A1:B2,majorDimension=COLUMNS`
+ # then `[[1,2],[3,4]]` will set `A1=1,B1=3,A2=2,B2=4`.
+ #
+ # When writing, if this field is not set, it defaults to ROWS.
+ "range": "A String", # The range the values cover, in A1 notation.
+ # For output, this range indicates the entire requested range,
+ # even though the values will exclude trailing rows and columns.
+ # When appending values, this field represents the range to search for a
+ # table, after which values will be appended.
+ },
},
],
}</pre>
@@ -777,6 +777,12 @@
The object takes the form of:
{ # The request for updating more than one range of values in a spreadsheet.
+ "valueInputOption": "A String", # How the input data should be interpreted.
+ "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.
+ # The default dateTime render option is
+ # DateTimeRenderOption.SERIAL_NUMBER.
"data": [ # The new values to apply to the spreadsheet.
{ # Data within a range of the spreadsheet.
"values": [ # The data that was read or to be written. This is an array of arrays,
@@ -793,11 +799,6 @@
"",
],
],
- "range": "A String", # The range the values cover, in A1 notation.
- # For output, this range indicates the entire requested range,
- # even though the values will exclude trailing rows and columns.
- # When appending values, this field represents the range to search for a
- # table, after which values will be appended.
"majorDimension": "A String", # The major dimension of the values.
#
# For output, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`,
@@ -811,6 +812,11 @@
# then `[[1,2],[3,4]]` will set `A1=1,B1=3,A2=2,B2=4`.
#
# When writing, if this field is not set, it defaults to ROWS.
+ "range": "A String", # The range the values cover, in A1 notation.
+ # For output, this range indicates the entire requested range,
+ # even though the values will exclude trailing rows and columns.
+ # When appending values, this field represents the range to search for a
+ # table, after which values will be appended.
},
],
"includeValuesInResponse": True or False, # Determines if the update response should include the values
@@ -822,12 +828,6 @@
# empty rows and columns).
"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.
- # The default dateTime render option is
- # DateTimeRenderOption.SERIAL_NUMBER.
- "valueInputOption": "A String", # How the input data should be interpreted.
}
x__xgafv: string, V1 error format.
@@ -839,20 +839,15 @@
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.
- "totalUpdatedSheets": 42, # The total number of sheets where at least one cell in the sheet was
- # updated.
"totalUpdatedCells": 42, # The total number of cells updated.
+ "totalUpdatedRows": 42, # The total number of rows where at least one cell in the row was updated.
"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.
+ "updatedColumns": 42, # The number of columns where at least one cell in the column 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
@@ -871,11 +866,6 @@
"",
],
],
- "range": "A String", # The range the values cover, in A1 notation.
- # For output, this range indicates the entire requested range,
- # even though the values will exclude trailing rows and columns.
- # When appending values, this field represents the range to search for a
- # table, after which values will be appended.
"majorDimension": "A String", # The major dimension of the values.
#
# For output, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`,
@@ -889,9 +879,19 @@
# then `[[1,2],[3,4]]` will set `A1=1,B1=3,A2=2,B2=4`.
#
# When writing, if this field is not set, it defaults to ROWS.
+ "range": "A String", # The range the values cover, in A1 notation.
+ # For output, this range indicates the entire requested range,
+ # even though the values will exclude trailing rows and columns.
+ # When appending values, this field represents the range to search for a
+ # table, after which values will be appended.
},
},
],
+ "totalUpdatedSheets": 42, # The total number of sheets where at least one cell in the sheet was
+ # updated.
+ "totalUpdatedColumns": 42, # The total 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>
@@ -910,12 +910,14 @@
{ # 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.
- # The default dateTime render option is
- # DateTimeRenderOption.SERIAL_NUMBER.
"valueInputOption": "A String", # How the input data should be interpreted.
+ "includeValuesInResponse": True or False, # Determines if the update response should include the values
+ # of the cells that were updated. By default, responses
+ # do not include the updated values. The `updatedData` field within
+ # each of the BatchUpdateValuesResponse.responses contains the updated
+ # 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).
"data": [ # The new values to apply to the spreadsheet. If more than one range is
# matched by the specified DataFilter the specified values are applied to
# all of those ranges.
@@ -933,6 +935,19 @@
# 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.
+ "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.
+ "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
@@ -946,21 +961,12 @@
# 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.
+ "metadataId": 42, # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_id.
"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
@@ -971,23 +977,18 @@
# 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.
+ "endIndex": 42, # The end (exclusive) of the span, or not set if unbounded.
+ "sheetId": 42, # The sheet this span is on.
},
+ "sheetId": 42, # The ID of the sheet when metadata is associated with an entire sheet.
},
- "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.
+ "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.
"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
+ # Indexes are half open, i.e. the start index is inclusive
# and the end index is exclusive -- [start_index, end_index).
# Missing indexes indicate the range is unbounded on that side.
#
@@ -1014,12 +1015,13 @@
# 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!`.
- "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.
+ "endRowIndex": 42, # The end row (exclusive) of the range, or not set if unbounded.
+ "sheetId": 42, # The sheet this range is on.
+ "startRowIndex": 42, # The start row (inclusive) of the range, or not set if unbounded.
},
+ "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
@@ -1031,13 +1033,11 @@
],
},
],
- "includeValuesInResponse": True or False, # Determines if the update response should include the values
- # of the cells that were updated. By default, responses
- # do not include the updated values. The `updatedData` field within
- # each of the BatchUpdateValuesResponse.responses contains the updated
- # 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).
+ "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.
+ # The default dateTime render option is
+ # DateTimeRenderOption.SERIAL_NUMBER.
}
x__xgafv: string, V1 error format.
@@ -1049,17 +1049,17 @@
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.
+ "totalUpdatedSheets": 42, # The total number of sheets where at least one cell in the sheet was
+ # updated.
"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.
- "totalUpdatedSheets": 42, # The total number of sheets where at least one cell in the sheet was
- # updated.
"totalUpdatedCells": 42, # The total number of cells updated.
+ "spreadsheetId": "A String", # The spreadsheet the updates were applied to.
"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.
+ "updatedRows": 42, # The number of rows where at least one cell in the row 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`.
@@ -1077,11 +1077,6 @@
"",
],
],
- "range": "A String", # The range the values cover, in A1 notation.
- # For output, this range indicates the entire requested range,
- # even though the values will exclude trailing rows and columns.
- # When appending values, this field represents the range to search for a
- # table, after which values will be appended.
"majorDimension": "A String", # The major dimension of the values.
#
# For output, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`,
@@ -1095,6 +1090,11 @@
# then `[[1,2],[3,4]]` will set `A1=1,B1=3,A2=2,B2=4`.
#
# When writing, if this field is not set, it defaults to ROWS.
+ "range": "A String", # The range the values cover, in A1 notation.
+ # For output, this range indicates the entire requested range,
+ # even though the values will exclude trailing rows and columns.
+ # When appending values, this field represents the range to search for a
+ # table, after which values will be appended.
},
"dataFilter": { # Filter that describes what data should be selected or returned from a # The data filter that selected the range that was updated.
# request.
@@ -1108,6 +1108,19 @@
# 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.
+ "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.
+ "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
@@ -1121,21 +1134,12 @@
# 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.
+ "metadataId": 42, # Limits the selected developer metadata to that which has a matching
+ # DeveloperMetadata.metadata_id.
"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
@@ -1146,23 +1150,18 @@
# 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.
+ "endIndex": 42, # The end (exclusive) of the span, or not set if unbounded.
+ "sheetId": 42, # The sheet this span is on.
},
+ "sheetId": 42, # The ID of the sheet when metadata is associated with an entire sheet.
},
- "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.
+ "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.
"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
+ # Indexes are half open, i.e. the start index is inclusive
# and the end index is exclusive -- [start_index, end_index).
# Missing indexes indicate the range is unbounded on that side.
#
@@ -1189,15 +1188,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!`.
- "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.
+ "endRowIndex": 42, # The end row (exclusive) of the range, or not set if unbounded.
+ "sheetId": 42, # The sheet this range is on.
+ "startRowIndex": 42, # The start row (inclusive) of the range, or not set if unbounded.
},
+ "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.
+ "updatedColumns": 42, # The number of columns where at least one cell in the column was updated.
"updatedCells": 42, # The number of cells updated.
},
],
@@ -1238,7 +1238,7 @@
</div>
<div class="method">
- <code class="details" id="get">get(spreadsheetId, range, dateTimeRenderOption=None, majorDimension=None, valueRenderOption=None, x__xgafv=None)</code>
+ <code class="details" id="get">get(spreadsheetId, range, dateTimeRenderOption=None, valueRenderOption=None, majorDimension=None, x__xgafv=None)</code>
<pre>Returns a range of values from a spreadsheet.
The caller must specify the spreadsheet ID and a range.
@@ -1249,14 +1249,14 @@
This is ignored if value_render_option is
FORMATTED_VALUE.
The default dateTime render option is [DateTimeRenderOption.SERIAL_NUMBER].
+ valueRenderOption: string, How values should be represented in the output.
+The default render option is ValueRenderOption.FORMATTED_VALUE.
majorDimension: string, The major dimension that results should use.
For example, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`, then
requesting `range=A1:B2,majorDimension=ROWS` returns `[[1,2],[3,4]]`,
whereas requesting `range=A1:B2,majorDimension=COLUMNS` returns
`[[1,3],[2,4]]`.
- valueRenderOption: string, How values should be represented in the output.
-The default render option is ValueRenderOption.FORMATTED_VALUE.
x__xgafv: string, V1 error format.
Allowed values
1 - v1 error format
@@ -1280,11 +1280,6 @@
"",
],
],
- "range": "A String", # The range the values cover, in A1 notation.
- # For output, this range indicates the entire requested range,
- # even though the values will exclude trailing rows and columns.
- # When appending values, this field represents the range to search for a
- # table, after which values will be appended.
"majorDimension": "A String", # The major dimension of the values.
#
# For output, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`,
@@ -1298,11 +1293,16 @@
# then `[[1,2],[3,4]]` will set `A1=1,B1=3,A2=2,B2=4`.
#
# When writing, if this field is not set, it defaults to ROWS.
+ "range": "A String", # The range the values cover, in A1 notation.
+ # For output, this range indicates the entire requested range,
+ # even though the values will exclude trailing rows and columns.
+ # When appending values, this field represents the range to search for a
+ # table, after which values will be appended.
}</pre>
</div>
<div class="method">
- <code class="details" id="update">update(spreadsheetId, range, body=None, responseValueRenderOption=None, responseDateTimeRenderOption=None, valueInputOption=None, includeValuesInResponse=None, x__xgafv=None)</code>
+ <code class="details" id="update">update(spreadsheetId, range, body=None, responseValueRenderOption=None, responseDateTimeRenderOption=None, includeValuesInResponse=None, valueInputOption=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.
@@ -1328,11 +1328,6 @@
"",
],
],
- "range": "A String", # The range the values cover, in A1 notation.
- # For output, this range indicates the entire requested range,
- # even though the values will exclude trailing rows and columns.
- # When appending values, this field represents the range to search for a
- # table, after which values will be appended.
"majorDimension": "A String", # The major dimension of the values.
#
# For output, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`,
@@ -1346,6 +1341,11 @@
# then `[[1,2],[3,4]]` will set `A1=1,B1=3,A2=2,B2=4`.
#
# When writing, if this field is not set, it defaults to ROWS.
+ "range": "A String", # The range the values cover, in A1 notation.
+ # For output, this range indicates the entire requested range,
+ # even though the values will exclude trailing rows and columns.
+ # When appending values, this field represents the range to search for a
+ # table, after which values will be appended.
}
responseValueRenderOption: string, Determines how values in the response should be rendered.
@@ -1355,13 +1355,13 @@
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 updated. By default, responses
do not include the updated 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).
+ valueInputOption: string, How the input data should be interpreted.
x__xgafv: string, V1 error format.
Allowed values
1 - v1 error format
@@ -1372,9 +1372,9 @@
{ # 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.
+ "updatedColumns": 42, # The number of columns where at least one cell in the column 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
@@ -1393,11 +1393,6 @@
"",
],
],
- "range": "A String", # The range the values cover, in A1 notation.
- # For output, this range indicates the entire requested range,
- # even though the values will exclude trailing rows and columns.
- # When appending values, this field represents the range to search for a
- # table, after which values will be appended.
"majorDimension": "A String", # The major dimension of the values.
#
# For output, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`,
@@ -1411,6 +1406,11 @@
# then `[[1,2],[3,4]]` will set `A1=1,B1=3,A2=2,B2=4`.
#
# When writing, if this field is not set, it defaults to ROWS.
+ "range": "A String", # The range the values cover, in A1 notation.
+ # For output, this range indicates the entire requested range,
+ # even though the values will exclude trailing rows and columns.
+ # When appending values, this field represents the range to search for a
+ # table, after which values will be appended.
},
}</pre>
</div>