Feishu Node icon

Feishu Node

Feishu Node

Actions105

电子表格 → 替换单元格

AI-generated

Summary

Searches a specified range in a Feishu spreadsheet and replaces matching text in its cells.

Inputs

  • authentication — Credential type: user-level or application-level credentials. Defaults to application-level credentials.
  • spreadsheetToke (required) — Spreadsheet token.
  • sheetId (required) — Worksheet ID.
  • range (required) — Range to search, formatted as !:.
  • find (required) — Text to find.
  • replacement (required) — Replacement text.
  • matchCase — Whether matching is case-sensitive. Defaults to false.
  • matchEntireCell — Whether the search text must match the entire cell. Defaults to false.
  • searchByRegex — Whether to interpret the search text as a regular expression. Defaults to false.
  • includeFormulas — Whether to search cell formulas. Defaults to false.

Output shape

A list of items, with each item's JSON derived from the API response.

The operation runs once for each incoming item; the source does not show the response fields or whether the API returns updated cell data.

Examples

Example 1: Replace matching text in a selected worksheet range

Provide the spreadsheet token, worksheet ID, range, search text, and replacement text; adjust the match options as needed.

Links

Discussion