Get visible row numbers Version 4 (Net)

Action group: Excel 

Description

The action writes the addresses of visible (displayed) rows to the collection after filtering has been applied.

Action icon


Settings of parameters

ParameterDescription
ContextAction context for working with an Excel document.
Column nameName of the column to which the action will be applied. If the field is not filled, then the value from the "Column index" field is taken.
Column indexIndex of the column to which the action will be applied.

Output parameters

The output is a collection of the visible row numbers.

Settings

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel document.Robin.ExcelExcel contextYes
Column nameName of the column to which the action will be applied. If the field is not filled, then the value from the "Column index" field is taken.Robin.String
No
Column indexIndex of the column to which the action will be applied.Robin.Numeric
No
Results
ResultThe variable in which the addresses of the visible rows will be written.Robin.Collection

Special conditions of use

The output should be a collection with visible rows in the format 1, 4, 6, and so on. 

Example of use

Task

There is an Excel-document. Select visible row numbers from column A within the range used.

Solution

Use the "Open", "Get visible row numbers" actions.

Implementation

  1. Assemble a robot scheme with the actions:
  2. Set the "Open" action parameters.
  3. Set the "Get visible row numbers" action parameters.
  4. Click "Start" in the top panel.

Result

The program robot completed successfully. The collection with the visible row numbers was obtained.

  • Нет меток