Сравнение версий

Ключ

  • Эта строка добавлена.
  • Эта строка удалена.
  • Изменено форматирование.

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 example
Mandatory field
Mandatory 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 

Image Modified

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:
    Image Modified
  2. Set the parameters for the "Table from CSV" action.
    Image Modified
  3. Set the parameters for the "Clear cell" action. 
  4. Set the parameters for the "Table to CSV" action. 
    Image Modified
  5. Click the "Start" button in the top panel. 

Result

The program robot completed successfully. 

...