Replace cells ​

Function Description ​

TIP

Replace eligible cells within the specified range of the spreadsheet

Configuration Item Description ​

General ​

Command Input

  • Feishu Application ObjectTFeiShu: Create a Feishu application object using the Feishu spreadsheet connection

  • Worksheet namestring: Sheet name to replace cells

  • Scopestring: To replace the range of cells

  • Search for textstring: The text to be searched for

  • Replace Textstring: The text to be replaced with

  • Replacement methodInteger: Replacement method, optional [Region, Row, Column]

  • Ignore capitalizationBoolean: Do you want to ignore capitalization

  • Match CellsBoolean: Does it match the entire cell

  • Search cell formulaBoolean: Do you only search for cell formulas

Command Output

No output for the current command

Error Handling ​

  • Print Error LogsBoolean: Whether to print error logs to the "Logs" panel when the command fails. Default is checked.

  • Handling MethodInteger:

    • Terminate Process: If the command fails, terminate the process.

    • Ignore Exception and Continue Execution: If the command fails, ignore the exception and continue the process.

    • Retry This Command: If the command fails, retry the command a specified number of times with a specified interval between retries.

Usage Example ​

Process logic description:

Common Errors and Handling ​

None

Frequently Asked Questions ​

None