API Reference

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

ParameterInTypeRequiredDescription
spreadsheetIdpathstringtrueThe unique identifier of the spreadsheet
sheetIdpathstringtrueThe unique identifier of the sheet
rangepathstringtrueThe range of values, in A1-style notation
bodybodyRangeValuestrueAll 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.json())

Returns

202 - Accepted

HeaderDescription
LocationThe location to poll for the operation result.
Retry-AfterThe number of seconds to wait before polling for a result and between polling attempts.