Hide rows Version 9 (net)

Action group: Excel 

Description

The action hides rows in the document

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel documentRobin.ExcelExcel contextYes
Start rowOrdinal number of the starting row of the range of rows to be hidden.Robin.Numeric
Yes
End rowOrdinal number of the end row of the range of rows to be hidden. If the value in this field is 0 or the value in the start row field, then only one row will be hidden.Robin.Numeric
No

Special conditions of use

The action hides one row if To equals to From or left empty.

The action hides all rows in the "From" to "To" range (or vice versa if the "To" field is set and the value is bigger than "From").

Example of use

Task

There is an excel-document. Hide rows 2 through 4.

Solution

Use the "Open", "Hide rows", Save" actions.

Implementation 

  1. Assemble a robot scheme with the actions.

2. Set the "Open" action parameters.

 

3. Set the "Hide rows" action parameters.

4. Set the "Save" action parameters.

5. Click "Start" in the top panel.

Result 

The program robot completed successfully.

The rows 2 through 4 were hidden.