Action group: Office
The action finds and replaces a value in the document
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Context | Action context for working with ods/xlsx table. | Robin.OpenSheetD oc | Yes | |
| Find | The value to be found. | Robin.String | Yes | |
| Replace with | The value by which the searched text will be replaced. If the field is not filled in, the searched text will be cut out of the cell. | Robin.String | No | |
| Replacement mode | Text replacement mode. The default value is «Replace first match» | Robin.String | No | |
| Account register | If «true», the case of the letters of the searched value will be taken into account. | Robin.Boolean | true | No |
| Search method | The rule that will be used to compare the value from the cell with the searched text when searching for a matching cell or cells. The default value is «Full match to text». | Robin.String | No | |
| Results | ||||
| Result | Dictionary with modified cells, where key is the cell address, value is the modified cell value. | Robin.Dictionary | ||
None.
There is a table with numbers, you need to replace the values 3 with 11.
Use the actions "Open", "Find and replace", "Save".
2. Set the "Path to file" parameter for the "Open" action. In the "Context" parameter specify the context of the opened tabular document "Test 1".
3. Set the parameters for the "Find and replace" action.
4. Set parameters for the "Save" action. In the "Context" parameter specify the context of the opened tabular document "Test 1".
5. Launch the robot using the "Start" button in the top panel.
The program robot completed successfully.
Values have been replaced.
