Find text Version 13 (.Net)
Action group: Excel
Description
The action returns the address of the cell that contains the given text.
Action icon
Settings of parameters
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Context | Action context for working with an Excel document | Robin.Excel | Excel context | Yes |
| Start cell column name | The column name of the starting cell from which the search will be performed. If the field is not filled, then the value from the «Start cell column index» field is taken. | Robin.String | No | |
| Start cell column index | The column index of the starting cell from which the search will be performed. If the field is not filled, then the border of the used area is taken. | Robin.Numeric | No | |
| Start cell row | Row of the starting cell from which the search will be performed. By default, the bounds of the used area are applied from the context. | Robin.Numeric | No | |
| End cell column name | The column name of the ending cell to which the search will be performed. If the field is not filled, then the value from the «End cell column index» field is taken. | Robin.String | No | |
| End cell column index | The column index of the ending cell to which the search will be performed. If the field is not filled, then the border of the used area is taken. | Robin.Numeric | No | |
| End cell row | Row of the destination cell to which the search will be performed. By default, the bounds of the used area are applied from the context. | Robin.Numeric | 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 | Dictionary with elements - found cells: element key = cell address, element value = cell value. | Robin.Dictionary | ||
Special conditions of use
If the search range field is not specified, the search is performed over the entire usable area on the sheet.
Example of use
Task
There is an Excel-document.
Find the word "RUB" or text in this document.
Solution
Use the "Open", "Find text", "Save" actions.
Implementation
- Assemble a robot scheme with the actions.
2. Set the "Open 1" action parameters.
3. Set the "Find text" action parameters.
4. Set the "Save" action parameters.
5. Click "Start" and see the result.
Result
The desired word was found successfully.
Обзор
Инструменты контента