Get data cell Version 6 (Net)

Action group: Tables

Description

This action is designed to retrieve data from a table cell.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
Data tableThe table from which the data will be retrieved.Robin.DataTable
Yes
Column nameИмя столбца, из которого будут получены данные. Если поле не заполнено, то берется значение из поля «Индекс столбца».Robin.String
No
Column indexThe number of the column from which the data will be retrieved. Numbering starts from 0. If the Column Name field is filled in, then the value in the Column Index field is ignored. The default value is «0».Robin.Numeric
No
Row indexThe row number from which the data will be retrieved. Numbering starts from 0.Robin.Numeric
Yes
Results
ResultThe data received from the specified cell.Robin.String

The syntax of the applied functions can be examined by the example of the following table, 

The INDEX parameter searches for data in the range at the intersection of the specified row and column/column, returning the result to a predesignated cell. The sheet coordinates are specified for the array.

It has the following syntax: =INDEX(array;column_number).

The column number does not mean the number on the sheet coordinates, but the order within the specified array itself

INDEX(array;column_number)

Array is a reference to a range of cells.

Column_number - the number of the column in the array from which you want to return a value. 

The values of the "column_number" arguments must point to a column within the specified array; otherwise, the INDEX() function will return an error.

Special conditions of use

None.

Example of use 

Task

There is a table  in CSV format.

 

It is necessary to get data from cell A1. 

Solution

Use "Get table from CSV", "Count columns",  "Get data cell" 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 "Get data cell" action. 


  4. Start the robot using the "Start" button in the top panel. 

Result

The program robot completed successfully. 

The data from the cell has been retrieved.

  • Нет меток