Update values in a range

Description

Overwrites all values in a range with new values. The provided range must not exceed the specified range. If the provided range of values is smaller than the specified range, it clears all cells in the range and those not covered by the range values. Rows of values in the provided range must be of equal length. An empty range of values is valid and may be used to clear a range.
To indicate that a cell's value shouldn't be replaced, use the special cell value null.
When you add a value to a cell, it uses Ones scale regardless of the cell's scale formatting.

PUT /spreadsheets/{spreadsheetId}/sheets/{sheetId}/values/{range}

🚧
Required OAuth Scopes:
file:write

Parameters

Parameter	In	Type	Required	Description
spreadsheetId	path	string	true	The unique identifier of the spreadsheet
sheetId	path	string	true	The unique identifier of the sheet
range	path	string	true	The range of values, in A1-style notation
body	body	RangeValues	true	All values for the range, not just those to update

Body parameter example

{
  "values": [
    [
      1,
      4
    ],
    [
      2,
      ""
    ]
  ]
}

Code Samples

curl -X PUT https://api.app.wdesk.com/platform/v1/spreadsheets/{spreadsheetId}/sheets/{sheetId}/values/{range}  \ 
-H 'Content-Type: application/json' \ 
-H 'Authorization: Bearer {access-token}'

http PUT https://api.app.wdesk.com/platform/v1/spreadsheets/{spreadsheetId}/sheets/{sheetId}/values/{range}  \ 
Content-Type:application/json \ 
Authorization:"Bearer {access-token}"

wget --method=PUT "https://api.app.wdesk.com/platform/v1/spreadsheets/{spreadsheetId}/sheets/{sheetId}/values/{range}" \
 --output-document -  \ 
 --header 'Content-Type: application/json' \ 
 --header 'Authorization: Bearer {access-token}'

import requests
headers = {
  'Content-Type': 'application/json',
  'Authorization': 'Bearer {access-token}'
}

r = requests.put('https://api.app.wdesk.com/platform/v1/spreadsheets/{spreadsheetId}/sheets/{sheetId}/values/{range}', headers = headers)

print(r.headers['Location'])

Returns

202 - Accepted

Header	Description
Location	The location to poll for the operation result.
Retry-After	The number of seconds to wait before polling for a result and between polling attempts.