插入数据

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

该接口用于根据 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":4,"spreadsheetToken":"shtcnyAti49vOKImQyn4ZH8rzLg","tableRange":"1QXD0s!A1:C1","updates":{"revision":4,"spreadsheetToken":"shtcnyAti49vOKImQyn4ZH8rzLg","updatedCells":3,"updatedColumns":3,"updatedRange":"1QXD0s!A1:C1","updatedRows":1}},"msg":"success"}