Get row number Version 12 (Net)

Action group: Excel 

Description

The action returns the number of rows. Rows within the context range used are counted. If you enter a column outside this range, the action will return an empty result.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel documentRobin.ExcelExcel contextYes
Column nameName of the column for which you want to get the number of rows. If the field is not filled, then the value from the «Column index» field is taken.Robin.String
No
Column indexIndex of the column for which you want to get the number of rows.Robin.Numeric
No
Skip hiddenRead only visible rowsRobin.BooleantrueNo
Skip emptyRead only filled rowsRobin.BooleantrueNo
Results
ResultThe variable in which the number of lines will be writtenRobin.Numeric

Special conditions of use

Rows within the used context range are counted.

If you enter a column outside this range, the action will produce an empty result.


Example of use

Task

There is an Excel document. You need to get the number of rows within the used context range of column A.

Solution

You need to use the following actions - "Open", "Get Row number".

Implementation 

  1. Assemble a robot scheme consisting of actions:

  2. Set the parameters for the "Open" action. 
  3. Set the parameters for the "Get row number" action. 
  4. Click on the "Start" button in the top panel. 

Result

A result is obtained with data from the specified column.