Lines Matching full:values
75 ….spreadsheets.html">spreadsheets</a> . <a href="sheets_v4.spreadsheets.values.html">values</a></h1>
79 <p class="firstline">Appends values to a spreadsheet. The input range is used to search for</p>
82 <p class="firstline">Clears one or more ranges of values from a spreadsheet.</p>
85 <p class="firstline">Returns one or more ranges of values from a spreadsheet.</p>
88 <p class="firstline">Sets values in one or more ranges of a spreadsheet.</p>
91 <p class="firstline">Clears values from a spreadsheet.</p>
94 <p class="firstline">Returns a range of values from a spreadsheet.</p>
97 <p class="firstline">Sets values in a range of a spreadsheet.</p>
101 <pre>Appends values to a spreadsheet. The input range is used to search for
102 existing data and find a "table" within that range. Values will be
105 [guide](/sheets/api/guides/values#appending_values)
119 Values will be appended after the last row of the table. (required)
124 "range": "A String", # The range the values cover, in A1 notation.
126 # even though the values will exclude trailing rows and columns.
127 # When appending values, this field represents the range to search for a
128 # table, after which values will be appended.
129 "values": [ # The data that was read or to be written. This is an array of arrays,
137 # Null values will be skipped.
143 "majorDimension": "A String", # The major dimension of the values.
160 Allowed values
163 responseValueRenderOption: string, Determines how values in the response should be rendered.
166 includeValuesInResponse: boolean, Determines if the update response should include the values
168 do not include the updated values.
177 { # The response when updating a range of values in a spreadsheet.
179 …"tableRange": "A String", # The range (in A1 notation) of the table that values are being appended…
180 # (before the values were appended).
182 …"updates": { # The response when updating a range of values in a spreadsheet. # Information about …
186 …"updatedData": { # Data within a range of the spreadsheet. # The values of the cells after updates…
189 "range": "A String", # The range the values cover, in A1 notation.
191 # even though the values will exclude trailing rows and columns.
192 # When appending values, this field represents the range to search for a
193 # table, after which values will be appended.
194 "values": [ # The data that was read or to be written. This is an array of arrays,
202 # Null values will be skipped.
208 "majorDimension": "A String", # The major dimension of the values.
230 <pre>Clears one or more ranges of values from a spreadsheet.
232 Only values are cleared -- all other properties of the cell (such as
240 { # The request for clearing more than one range of values in a spreadsheet.
247 Allowed values
254 { # The response when clearing a range of values in a spreadsheet.
267 <pre>Returns one or more ranges of values from a spreadsheet.
279 ranges: string, The A1 notation of the values to retrieve. (repeated)
284 valueRenderOption: string, How values should be represented in the output.
287 Allowed values
294 { # The response when retrieving more than one range of values in a spreadsheet.
296 "valueRanges": [ # The requested values. The order of the ValueRanges is the same as the
299 "range": "A String", # The range the values cover, in A1 notation.
301 # even though the values will exclude trailing rows and columns.
302 # When appending values, this field represents the range to search for a
303 # table, after which values will be appended.
304 "values": [ # The data that was read or to be written. This is an array of arrays,
312 # Null values will be skipped.
318 "majorDimension": "A String", # The major dimension of the values.
338 <pre>Sets values in one or more ranges of a spreadsheet.
348 { # The request for updating more than one range of values in a spreadsheet.
350 "data": [ # The new values to apply to the spreadsheet.
352 "range": "A String", # The range the values cover, in A1 notation.
354 # even though the values will exclude trailing rows and columns.
355 # When appending values, this field represents the range to search for a
356 # table, after which values will be appended.
357 "values": [ # The data that was read or to be written. This is an array of arrays,
365 # Null values will be skipped.
371 "majorDimension": "A String", # The major dimension of the values.
391 …"responseValueRenderOption": "A String", # Determines how values in the response should be rendere…
393 …ludeValuesInResponse": True or False, # Determines if the update response should include the values
395 # do not include the updated values. The `updatedData` field within
397 # the updated values. If the range to write was larger than than the range
398 # actually written, the response will include all values in the requested
403 Allowed values
410 { # The response when updating a range of values in a spreadsheet.
413 { # The response when updating a range of values in a spreadsheet.
417 …"updatedData": { # Data within a range of the spreadsheet. # The values of the cells after updates…
420 "range": "A String", # The range the values cover, in A1 notation.
422 # even though the values will exclude trailing rows and columns.
423 # When appending values, this field represents the range to search for a
424 # table, after which values will be appended.
425 "values": [ # The data that was read or to be written. This is an array of arrays,
433 # Null values will be skipped.
439 "majorDimension": "A String", # The major dimension of the values.
469 <pre>Clears values from a spreadsheet.
471 Only values are cleared -- all other properties of the cell (such as
476 range: string, The A1 notation of the values to clear. (required)
480 { # The request for clearing a range of values in a spreadsheet.
484 Allowed values
491 { # The response when clearing a range of values in a spreadsheet.
502 <pre>Returns a range of values from a spreadsheet.
507 range: string, The A1 notation of the values to retrieve. (required)
519 valueRenderOption: string, How values should be represented in the output.
522 Allowed values
530 "range": "A String", # The range the values cover, in A1 notation.
532 # even though the values will exclude trailing rows and columns.
533 # When appending values, this field represents the range to search for a
534 # table, after which values will be appended.
535 "values": [ # The data that was read or to be written. This is an array of arrays,
543 # Null values will be skipped.
549 "majorDimension": "A String", # The major dimension of the values.
567 <pre>Sets values in a range of a spreadsheet.
573 range: string, The A1 notation of the values to update. (required)
578 "range": "A String", # The range the values cover, in A1 notation.
580 # even though the values will exclude trailing rows and columns.
581 # When appending values, this field represents the range to search for a
582 # table, after which values will be appended.
583 "values": [ # The data that was read or to be written. This is an array of arrays,
591 # Null values will be skipped.
597 "majorDimension": "A String", # The major dimension of the values.
614 Allowed values
617 responseValueRenderOption: string, Determines how values in the response should be rendered.
619 includeValuesInResponse: boolean, Determines if the update response should include the values
621 do not include the updated values.
623 the response will include all values in the requested range (excluding
633 { # The response when updating a range of values in a spreadsheet.
637 …"updatedData": { # Data within a range of the spreadsheet. # The values of the cells after updates…
640 "range": "A String", # The range the values cover, in A1 notation.
642 # even though the values will exclude trailing rows and columns.
643 # When appending values, this field represents the range to search for a
644 # table, after which values will be appended.
645 "values": [ # The data that was read or to be written. This is an array of arrays,
653 # Null values will be skipped.
659 "majorDimension": "A String", # The major dimension of the values.