向单个范围写入数据

PUT {{base_url}}/sheets/v2/spreadsheets/:spreadsheetToken/values

该接口用于根据 spreadsheetToken 和 range 向单个范围写入数据，若范围内有数据，将被更新覆盖；单次写入不超过5000行，100列，每个格子不超过5万字符。

参考接口文档：向单个范围写入数据

Request Body

{"valueRange"=>{"range"=>"1QXD0s!A1:B2", "values"=>[["Hello", 1], ["World", 1]]}}

RESPONSES

status: OK

{"code":0,"data":{"revision":11,"spreadsheetToken":"shtcnyAti49vOKImQyn4ZH8rzLg","updatedCells":4,"updatedColumns":2,"updatedRange":"1QXD0s!A1:B2","updatedRows":2},"msg":"success"}