Clear cell Version 3 (Net)

Action group: Tables

Description

This action is used to delete data from a table 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 in which the data will be cleared. If the field is not filled, then the value from the «Column index» field is taken.Robin.String
No
Column indexIndex of the column where data will be cleared. 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 where the data will be cleared. Indexing starts at 0.Robin.Numeric
Yes

Special conditions of use

None.

Example of use

Task

There is a table in CSV format 

You need to clear cell B3 and create a new edited document. 

Solution

Use the actions "Get table from CSV", "Clear cell", "Table to CSV". 

Implementation

  1. Assemble a robot scheme consisting of actions:

  2. Set the parameters for the "Table from CSV" action.

  3. Set the parameters for the "Clear cell" action. 
  4. Set the parameters for the "Table to CSV" action. 
  5. Click the "Start" button in the top panel. 

Result

The program robot completed successfully. 

The required cell is cleared. A new table is created. 

  • Нет меток