Action group: Excel
The action sequentially fills the cells of a given row with values from a given list, starting from some starting cell in the column
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Context | Action context for working with an Excel document | Robin.Excel | Excel context | Yes |
| Row | Row index from which the value will be set. If you enter a string outside the working range, the action will return an empty result. | Robin.Numeric | Yes | |
| Starting column name | Name of the column from which the value will be set. If the field is not filled, then the value from the «Starting column index» field is taken. | Robin.String | No | |
| Starting column index | The index of the column from which the value will be set. | Robin.Numeric | No | |
| A list of values | A list of values that will be used to fill cells in a row. | Robin.Collection | Yes | |
The "R1C1" link style is not supported.
There is an Excel-document. Add data to row 6 starting from column A.
Use the "Open", "Set row data", "Save" actions.
2. Set the "Open" action parameter.
3. Set the "Set row data" action parameter.
4. Set the "Save" action parameter.
5. Click "Start" in the top panel.
The program robot completed successfully.
The data was added to the desired row in the table.
