读取多个范围

GET {{base_url}}/sheets/v2/spreadsheets/:spreadsheetToken/values_batch_get?ranges=1QXD0s!A1:C3,1QXD0s!C3:D4

该接口用于根据 spreadsheetToken 和 ranges 读取表格多个范围的值，返回数据限制为10M。

参考接口文档：读取多个范围

Request Params

RESPONSES

status: OK

{"code":0,"data":{"revision":10,"spreadsheetToken":"shtcnyAti49vOKImQyn4ZH8rzLg","totalCells":13,"valueRanges":[{"majorDimension":"ROWS","range":"1QXD0s!A1:C3","revision":10,"values":[["string",1,[{"link":"http://www.xx.com","text":"http://www.xx.com","type":"url"}]],[null,null,null],[null,null,null]]},{"majorDimension":"ROWS","range":"1QXD0s!C3:D4","revision":10,"values":[[null,null],[null,null]]}]},"msg":"success"}