追加数据

POST {{base_url}}/sheets/v2/spreadsheets/:spreadsheetToken/values_append

该接口用于根据 spreadsheetToken 和 range 遇到空行则进行覆盖追加或新增行追加数据。 空行：默认该行第一个格子是空，则认为是空行；单次写入不超过5000行，100列，每个格子不超过5万字符。

参考接口文档：追加数据

Request Body

{"valueRange"=>{"range"=>"1QXD0s!A1:C1", "values"=>[["string", 1, "http://www.xx.com"]]}}

RESPONSES

status: OK

{"code":0,"data":{"revision":5,"spreadsheetToken":"shtcnyAti49vOKImQyn4ZH8rzLg","tableRange":"1QXD0s!A2:C2","updates":{"revision":5,"spreadsheetToken":"shtcnyAti49vOKImQyn4ZH8rzLg","updatedCells":3,"updatedColumns":3,"updatedRange":"1QXD0s!A2:C2","updatedRows":1}},"msg":"success"}