Count rows Version 3 (Python)

Action group: Tables

Description

This action is used to count the number of rows in the selected table.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
Data tableThe table in which to count the rows.Robin.DataTable
Yes
Skip headerIf the value is «true», then the first row of the table is skipped when counting.Robin.BooleantrueNo
Skip empty rowsIf the value is «true», the action will only count completed rows.Robin.BooleantrueNo
Results
ResultNumber of rows in the table.Robin.Numeric

Special conditions of use

None.

Example of use 

Task

There is a table in CSV format 

 

It is necessary to calculate the number of rows in the table without taking into account the table header.

Solution

Use "Get table from CSV", "Count rows" actions.

Implementation

  1. Assemble a robot consisting of actions:

  2. Set the parameters for the "Get table from CSV" action.
  3. Set the parameters for the "Count rows" action. 


  4. Click "Start" in the top panel.  

Result

The program robot completed successfully.

The number of rows in the table is obtained.