Lark icon

Lark

Consume Lark API

Actions118

表格 → 查找单元格

AI-generated

Summary

Searches a specified range in a Lark spreadsheet sheet for a keyword, with options for case sensitivity, whole-cell matching, regular expressions, and searching formulas.

Inputs

  • authentication — Choose Tenant Access Token or User Access Token authentication; the node requires the corresponding Lark credential.
  • spreadsheet_id (required) — Spreadsheet ID, entered directly or selected from the list.
  • sheet_id (required) — Sheet ID, entered directly or selected from the chosen spreadsheet.
  • range (required) — Cell range to search, in start:end format such as !A1:B2.
  • search_key (required) — Keyword or pattern to find.
  • options — Optional search settings: Ignore case, Match entire cell, Search using regular expression, and Search only cell formulas. Each defaults to false.

Output shape

A list of JSON items containing the Lark API search response.

The operation calls Lark's spreadsheet cell-find endpoint for the selected spreadsheet, sheet, range, and search key, passing the four option values. The exact fields in the response depend on Lark's API response.

Links

Discussion