API Reference

Update values in a range


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:



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": [

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)



202 - Accepted

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