删除下拉列表设置

DELETE {{base_url}}/sheets/v2/spreadsheets/:spreadsheetToken/dataValidation

该接口根据 spreadsheetToken 、range 移除选定数据范围单元格的下拉列表设置,但保留选项文本。单个删除范围不超过5000单元格。单次请求range最大数量100个。

参考接口文档:删除下拉列表设置

Request Body

{"dataValidationRanges"=>[{"range"=>"1QXD0s!A1:A100", "dataValidationIds"=>[1]}]}

RESPONSES

status: OK

{"code":0,"data":{"rangeResults":[{"msg":"","range":"1QXD0s!A1:A100","success":true,"updatedCells":100}]},"msg":"success"}