Set row data Version 12 (Net)

Action group: Excel 

Description

The action sequentially fills the cells of a given row with values from a given list, starting from some starting cell in the column

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel documentRobin.ExcelExcel contextYes
RowRow 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 nameName 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 indexThe index of the column from which the value will be set.Robin.Numeric
No
A list of valuesA list of values that will be used to fill cells in a row.Robin.Collection
Yes

Special conditions of use

The "R1C1" link style is not supported.

Example of use

Task

 There is an Excel-document. Add data to row 6 starting from column A.

Solution

Use the "Open", "Set row data", "Save" actions.

Implementation

  1. Assemble a robot scheme with the 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.


Result

The program robot completed successfully.

The data was added to the desired row in the table.

  • Нет меток