Update values in a range

Deprecated

This endpoint is deprecated and may be removed in a future release.

This endpoint was deprecated on 2026-02-12.

It is scheduled for sunset on 2029-01-31.

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 /platform/v1/spreadsheets/{spreadsheetId}/sheets/{sheetId}/values/{range}

Required OAuth Scopes

file:write

Parameters#

Parameter	In	Type	Required	Description
X-Version	header	string	false	Version of the API (2022-01-01)
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

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

httpie

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

wget

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

python

import requests

headers = {
  'X-Version': '2022-01-01',
  'Content-Type': 'application/json',
  'Accept': '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'])