A group of actions: Excel
The action returns the address of the cell that contains the given text.
Settings
Property | Description | Type | Filling example | Mandatory field |
Parameters | ||||
Context | Action context for working with an Excel document | Robin.Excel | Excel context | Yes |
Start cell | The address of the starting cell from which the search will be performed. Fill in the format «XY», where «X» is the column number and «Y» is the line number. By default, the bounds of the used area are applied from the context. | Robin.String | No | |
End cell | The address of the destination cell to which the search will be performed. Fill in the format «XY», where «X» is the column number and «Y» is the line number. By default, the bounds of the used area are applied from the context. | Robin.String | No | |
Skip hidden | Hidden cells will not be searched. | Robin.Boolean | true | No |
Text | The text to be searched for. | Robin.String | Yes | |
Search method | Search method. Full-text search will be applied by default. | Robin.String | No | |
Results | ||||
Result | Словарь с одним эдементом - результатом: ключ элемента = «результат», значение элемента = список адресованных ячеек, удовлетворяющих критерием поиска. | Robin.Dictionary |
Обзор
Инструменты контента