Show rows Version 9 (net)

Action group: Excel 

Description

The action shows hidden 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 start row of the range of hidden rows to be displayed.Robin.Numeric
Yes
End rowOrdinal number of the end row of the range of rows to be displayed. If the value in this field is 0 or the value in the start row field, then only one row will be displayed.Robin.Numeric
No

Special conditions of use

If one or all of the range rows are not hidden, the action with an error will not terminate.

Example of use 

Task

There is an Excel-document where rows number 6 and 7 are hidden. 

We need to make them visible.

Solution

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

Implementation 

  1. Assemble a robot scheme with the actions.
  2. Set the "Open" actions parameters.
  3. Set the "Show rows" 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 are displayed in the document.