Search for cells ​

Function Description ​

TIP

Search for cells that meet the criteria 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: The name of the sheet to be searched for

  • Scopestring: The scope of the sheet to be searched, for example A1: C2

  • Textstring: The cell text to be searched for

  • Matching rulesInteger: Cell content matching rules, can choose full matching or partial matching

Command Output

  • Cell ListTList<string>: Read a list of cells that meet the criteria

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