查找

POST {{base_url}}/sheets/v3/spreadsheets/:spreadsheet_token/sheets/:sheet_id/find

按照指定的条件查找子表的某个范围内的数据符合条件的单元格位置。请求体中的 range 和 find 字段为必填。

参考接口文档：查找

Request Body

{"find"=>"hello", "find_condition"=>{"include_formulas"=>false, "match_case"=>true, "match_entire_cell"=>false, "range"=>"1QXD0s!A1:H10", "search_by_regex"=>false}}

RESPONSES

status: OK

{"code":0,"data":{"find_result":{"matched_cells":["A1"],"matched_formula_cells":[],"rows_count":1}},"msg":"success"}