向多个范围写入数据

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

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

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

Request Body

{"valueRanges"=>[{"range"=>"1QXD0s!A6:B9", "values"=>[[6, 1], [6, 1], [6, 1], [6, 1]]}, {"range"=>"1QXD0s!A1:C2", "values"=>[["Hello", 2, "https://www.xx.com"], ["World", 2, "https://www.xx.com"]]}]}

RESPONSES

status: OK

{"code":0,"data":{"responses":[{"spreadsheetToken":"shtcnyAti49vOKImQyn4ZH8rzLg","updatedCells":8,"updatedColumns":2,"updatedRange":"1QXD0s!A6:B9","updatedRows":4},{"spreadsheetToken":"shtcnyAti49vOKImQyn4ZH8rzLg","updatedCells":6,"updatedColumns":3,"updatedRange":"1QXD0s!A1:C2","updatedRows":2}],"revision":12,"spreadsheetToken":"shtcnyAti49vOKImQyn4ZH8rzLg"},"msg":"success"}