A group of actions: None

The action searches for and returns the addresses of all cells that contain the given text

Settings

Property Description Type Filling example Mandatory field
Parameters
ContextAction context for ods/xlsx documentRobin.OpenSheetD oc
Yes
TextThe text to be searchedRobin.String
Yes
Start line numberThe row number of the starting cell of the text search range. Numbering starts from 1. Default value: index of the first line in the used area of the active sheet of the document.Robin.Numeric
No
End line numberOrdinal number of the end line of the text search range. Numbering starts from 1. By default, the search ends on the last line of the area usedRobin.Numeric
No
Start cell columnThe start column of the text search range. By default, the search starts from the first column of the area usedRobin.String
No
Destination cell columnEnd column of the text search range. By default, the search ends at the last column of the scope used.Robin.String
No
Search MethodText search method. All methods are not case sensitive. Default value: Full text search.Robin.String
No
Results
ResultDictionary with records - found cells: record key = cell address, record value = cell value.Robin.Dictionary

  • Нет меток