Add row Version 3 (Net)
Action group: Excel
Description
The action allows you to add a row on top of the row selected by index in an Excel document.
Action icon
Settings of parameters
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Context | Action context for working with an Excel documents | Robin.Excel | Excel context | Yes |
| Row index | The index of the row before which the new row is to be inserted. | Robin.Numeric | Yes | |
| Values | If the parameter is filled, then the new row will include the values from the collection. | Robin.Collection | No | |
Special conditions of use
None.
Example of use
Task
There is an Excel-document with a table.
Add a row with data after the first row in the table.
Solution
Use the "Open", "Add row", "Save" actions.
Implementation
- Assemble a robot scheme with the actions:
- Set the "Open" action parameters.
- Set the "Add row" action parameters.
In the "Value" field specify the data that will appear in the new row.
- Set the "Save" action parameters.
- Click "Start" in the top panel.
Result
The program robot completed successfully.
The new row was added to the table.
Обзор
Инструменты контента