Apply formula to cell Version 10 (

...

Net)

Action group: Excel 

...

Description

Executes a formula in the selected cell.

Action icon
Image Modified

Parameters 

Input parameters 

1. Context - Action context for working with an Excel document.
2. Column of cell - Column of the cell where the result of the formula calculation will be written. For example C.
3. Column index - The column index of the cell into which the result of the formula calculation will be written.
4. Row of the cell - The row of the cell into which the result of the formula calculation will be written. For example: 3.
5. Formula - The formula that will be used to perform the calculation in the cell. The formula begins with the symbol "=". For example: =5+5*5*2+C1.
6. Local language - If True, formula names will be given in the local language, otherwise in English. For example: true.
7. Register - If the parameter value is True, the formula string remains unchanged. If "False", then all letters in the formula become capitalized. The default is "False." For example: true.

Settings

Settings of parameters

Special conditions of use

...

1. Assemble a robot scheme consisting of actions:
   
2. Customize the parameters of the "Open" action:
   
3. Customize the parameters of the "Apply formula to cell" action:
   
4. Customize the "Save" action parameter :
   
5. Launch the robot using the "Start" button on the top panel. 

Result

The program robot completed successfully.

...