Clear cell Version 9 (Net)

Action group: Excel

Description

The action removes a value from the specified cell.

Icon

Parameters

Input parameters:  

  1. Context - Action context for working with Excel document;
  2. Column of the cell - Name of the column in which the data will be cleared. If the field is not filled in, the value from the "Column index" field is taken. For example: С;
  3. Column index - Index of the column in which the data will be cleared. Indexing starts from 0. If the "Column index" field is filled in, the value in the "Column index" field is ignored. The default value is "0";
  4. Row of the cell - The index of the row in which the data will be cleared. The indexing starts at 0. For example: 3.

Settings

Property

Description

Type

Example of filling in

Obligatory to fill in the field

Parameters

Context

Action context for working with an Excel document

Excel instance

Excel context

Yes

Column of the cell

Name of the column in which the data will be cleared. If the field is not filled in, the value from the "Column index" field is taken.

String


No

Column index

The index of the column in which the data will be cleared. Indexing starts from 0. If the "Column of the cell" field is filled in, the value in the "Column index" field is ignored. The default value is "0".

Numeric


No

Row of the cell

The index of the row in which the data will be cleared. Indexing starts from 0

Numeric


Yes

Special conditions of use

The "R1C1" reference style is not supported.

Example of use

Task

There is an Excel document in which values are written. It is required to clear the value in cell C3. 

image2024-1-23_15-33-16.png

Solution

Use the actions "Open", "Clear cell", "Save". 

Implementation

  1. Assemble a robot scheme consisting of the actions:
  2. Customize parameters for the "Open" action:
  3. Customize the parameters for the "Clear cell" action:


  4. Customize parameters for the "Save" action:
  5. Launch the robot using the "Start" button in the top panel. 

Result: 

The program robot completed successfully.

The value from cell C3 has been cleared.