Feishu Node icon

Feishu Node

Feishu Node

Actions105

电子表格 → 查找单元格

AI-generated

Summary

Searches a specified range in a Feishu spreadsheet for a string, with options to control case sensitivity, whole-cell matching, regular expressions, and formula searching.

Inputs

  • 凭证类型 — Choose user-level OAuth credentials or application-level credentials; application-level credentials are selected by default.
  • 电子表格 Token (required) — Token of the spreadsheet to search.
  • 工作表 ID (required) — ID of the worksheet.
  • 查找范围 (required) — Range to search, in the declared format <sheetId>!<start position>:<end position>.
  • 查找字符串 (required) — String to find.
  • 是否忽略查找字符串的大小写 — Whether to ignore case; defaults to false.
  • 字符串是否需要完全匹配整个单元格 — Whether the string must match the entire cell; defaults to false.
  • 是否使用正则表达式查找 — Whether to search using a regular expression; defaults to false.
  • 是否仅搜索单元格公式 — Whether to search only cell formulas; defaults to false.

Output shape

A list of output items containing returned JSON data from the Feishu API.

The operation runs once per incoming item and pairs each result with its input item. The source does not show the specific fields returned by the API.

Links

Discussion