Set row values Version 4 (Net)

Action group: Tables

Description

This action is used to set values in the specified row of the table.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
Data tableTable for which the action will be performed.Robin.DataTable
Yes
Row indexIndex of the string to set the values to. If there were already values in the line, they will be overwritten. If the index is greater than the existing one, the row will be added. Indexing starts at 0.Robin.Numeric
Yes
ValuesThe values to be written to the selected row.Robin.Collection
Yes

Special conditions of use

None.

Example of use 

Task

There is a table in CSV format 
  . 

It is necessary to change the values of line 2 to 

The Turn of the ScrewHenry Jamestrade paperback384$3.35

and create a new table with the updated data. 

Solution

Use "Get table from CSV", "Set row values",  "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 row values" 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 required values of line 2 have been changed.

 

  • Нет меток