A group of actions: SpreadSheets
The action returns the address of the cell containing the specified text.
Settings
Property | Description | Type | Filling example | Mandatory field |
Parameters | ||||
Context | Identifier of the session to which the action will be applied. | Robin.SpreadShee ts | SpreadSheets context | Yes |
Document ID | Identifier of the document to apply the action to. | Robin.String | Yes | |
Sheet | Name of working sheet. By default, the first sheet of the document. | Robin.String | No | |
Start cell column | Column of the initial cell from which the search will be performed. By default, the boundaries of the used area from the context are applied. | Robin.String | No | |
Start cell row | Row of the initial cell from which the search will be performed. By default, the boundaries of the used area from the context are applied. | Robin.Numeric | No | |
End Cell column | Column of the end cell to which the search will be performed. By default, the boundaries of the used area from the context are applied. | Robin.String | No | |
End Cell row | Row of the destination cell to which the search will be performed. By default, the boundaries of the used area from the context are applied. | Robin.Numeric | No | |
Text | Text to be searched for. | Robin.String | Yes | |
Skip hidden | Hidden cells will not participate in the search. | Robin.Boolean | true | No |
Search method | Search method. Full-text search will be applied by default. | Robin.String | No | |
Results | ||||
Result | Dictionary with elements - found cells: element key = cell address, element value = cell value. | Robin.Dictionary |
Обзор
Инструменты контента