Delete row Version 9 (Net)

Action group: Excel 

Description

The action deletes specified rows

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel documentRobin.ExcelExcel contextYes
Starting rowStarting row number to be removedRobin.Numeric
Yes
Final rowFinal row number to be removedRobin.Numeric
No

Special conditions of use

None.

Example of use

Task

There is an Excel-document. Delete rows 1 through 4.

Solution

Use the "Open", "Delete row", "Save" actions.

Implementation

  1. Assemble a robot scheme with the actions.
  2. Set the "Open" action parameters.

3. Set the "Delete row" action parameters.

4. Set the "Save" action parameters.

5. Click "Start" in the top panel to start the robot.

Result

The program robot completed successfully.

The desired rows were deleted.