En

Text Search#

Text search in an Excel document. To find the next cell with the specified text, the block can be reused.

Document link[Link] Link to the document currently being worked on. The variable name in this property must match the variable name in the "Document link" property of the "Create Document" or "Open Document" blocks from the Excel group that were previously used to create or open this document.
Sheet[Number/Text] ID (ordinal number) or name of the sheet where the required cell is located. Numbering starts from 1.
Text[Text] The string to be found.
Search Order

Specifies the search order. Possible values:

  • ByColumns - search is performed by columns;
  • ByRows - search is performed by rows.
From Row[Number] The row number from which the search begins. Numbering starts from 1. If the value is empty, the number will be equal to the minimum value.
From Column[Number] The column number from which the search begins. Numbering starts from 1. If the value is empty, the number will be equal to the minimum value.
Exact Cell MatchIf enabled, the cell content must match the entire search text.
Row[Number] If the text is found, the property returns the row number. Numbering starts from 1.
Column[Number] If the text is found, the property returns the column number. Numbering starts from 1.
Cell Address[Text] The address of the cell.
Error Handling Level

Select the error handling level. Possible values:

  • "Default" - default;
  • "Ignore" - errors are ignored;
  • "Handle" - errors are handled.

If "Default" is selected, the value of the "Start" block of this diagram will be used.

Exit Direction

Select the exit direction from the block in case of an error. Possible values:

  • "Default" - default;
  • "Right" - to the right;
  • "Bottom" - down.

This property allows you to determine the exit direction in case of errors for blocks that do not contain the "If Error" connector (for example, the "Condition" block). If "Default" is selected, the value of the "Start" block of this diagram will be used.

Message Level

Select the message level that the blocks will output during operation. Possible values:

  • "Default" - default;
  • "Release" - output is disabled;
  • "Debug" - main information output;
  • "Detailed" - detailed information output.

If "Default" is selected, the value of the "Start" block of this diagram will be used.

Error Text[Text] Returns detailed information about the error in case of incorrect execution of the block's work.