替换

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

按照指定的条件查找子表的某个范围内的数据符合条件的单元格并替换值，返回替换成功的单元格位置。一次请求最多允许替换5000个单元格，如果超过请将range缩小范围再操作。请求体中的 range、find、replaccement 字段必填。

参考接口文档：替换

Request Body

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

RESPONSES

status: OK

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