Set cell value Version 9 (Net)

Action group: Excel 

Description

The action sets the value to the specified cell.

Action icon

Settings of parameters

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

The column of the cell to which the value will be written. If there is already data in the cell, it will be overwritten. The format of the value in the cell will be "General"

String


No

Column index

The column index of the cell to which the value will be written. If there is already data in the cell, it will be overwritten. The format of the value in the cell will be "General"

Numeric


No

Row of the cell

The cell row in which the value will be written. If there is already data in the cell, it will be overwritten. The format of the value in the cell will be "General"

Numeric


Yes

Value

The value to be written to the selected cell

Object


Yes

Special conditions for use  

If there is already data in the cell, it will be overwritten.

Example of use  

Task

There is an Excel document in which values are written. It is required to set the value 23 in cell C4. 

Solution

Use the actions "Open", "Set cell value", "Save". 

Implementation

  1. Assemble a robot scheme consisting of actions:
  2. Customize the parameters for the "Open" action:
  3. Set the parameters for the "Set cell value" action:
  4. Set the 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 23 is written in cell C4.