Set cell value Version 3 (Net)

Action group: Tables

Description

This action is used to set a value in the specified cell.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
Data tableTable for which the action will be performed.Robin.DataTable
Yes
Column nameName of the column for which the data will be set. 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 the data will be set. Indexing starts at 0. If the «Column name» field is filled in, the value in the «Column index» field is ignored. Default value is «0».Robin.Numeric
No
Row indexIndex of the row for which the data will be set. Indexing starts at 0.Robin.Numeric
Yes
ValueValue to be written to the selected cell. If there was already some value in the selected cell, it will be overwritten.Robin.Object
Yes

Special conditions of use

None.

Example of use 

Task

There is a table in CSV format 

  . 

You need to insert the value 462 into cell D3 and create a new table with the updated data. 

Solution

Use "Get table from CSV", "Set cell value",  "Table to CSV" 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 "Set cell value" action. 
  4. Set the parameters for the "Table to CSV" action. 


  5. Click "Start" in the top panel.  

Result

The program robot completed successfully. 

The cell is filled.

 

  • Нет меток