Run formula

Action group: Office

Description

The action sets a formula in the cell and executes it to calculate a value

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with ods/xlsx table.Robin.OpenSheetD oc
Yes

Cell column

The column of the cell whose value the action will return.

Robin.String


Yes

Cell row

The cell row whose value from which the action will return.

Robin.Numeric


Yes

Formula

The formula to be set and executed in the cell. The formula starts with the "=" symbol

Robin.String


Yes

Sheet

Name of the worksheet. By default, the first sheet of the document

Robin.String


No

Local language

If the value is "true", the formula must be specified in the local language, otherwise in English.

Robin.Boolean

true

No

Special conditions of use

None.

Example of use

Task

There is a file Book1.xlsx, it is necessary to execute formula A1+A2 (result in cell A3), save and close the document. 

Solution

Use the actions "Open", "Run formula", "Save".

Implementation

  1. Move the "Open" action to the workspace and set its parameters
    In the "File path" field specify the path to the file Book1.xlsx





  2. Move the "Execute formula" action to the workspace and fill in its parameters
    In the "Context" field, specify the context created in step 1.
    In the "Cell Column" field specify the value = A.
    In the "Cell row" field specify the value = 3. 
    In the "Formula" field specify the value = A1+A2 (English). 

  3. Move the "Save" action to the workspace and set its parameter.
    In the "Context" field specify the context of the opened document.

  4. Move the "Close" action to the workspace and set its parameter.


  5. Launch the robot using the "Start" button in the top panel.

Result

The program robot completed successfully.

The formula is executed in cell A3.

The file is saved and closed.