设置下拉列表

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

该接口根据 spreadsheetToken 、range 和下拉列表属性给单元格设置下拉列表规则；单次设置范围不超过5000行，100列。当一个数据区域中已有数据，支持将有效数据直接转为选项。

参考接口文档：设置下拉列表

Request Body

{"range"=>"1QXD0s!A1:A100", "dataValidationType"=>"list", "dataValidation"=>{"conditionValues"=>["2", "89", "3"], "options"=>{"multipleValues"=>true, "highlightValidData"=>true, "colors"=>["#1FB6C1", "#F006C2", "#FB16C3"]}}}

RESPONSES

status: OK

{"code":0,"data":{},"msg":"success"}