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

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel documentsRobin.ExcelExcel contextYes
Row indexThe index of the row before which the new row is to be inserted.Robin.Numeric
Yes
ValuesIf 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

  1. Assemble a robot scheme with the actions:
  2. Set the "Open" action parameters.
  3. Set the "Add row" action parameters.

    In the "Value" field specify the data that will appear in the new row.
  4. Set the "Save" action parameters.
  5. Click "Start" in the top panel.

Result

The program robot completed successfully.

The new row was added to the table.