When to use the WriteCellFormula activity
This activity helps you apply a formula to a specified cell.
Figure 1
|
Activity Name |
Picture |
|
WriteCellFormula |
|
|
Figure 1.1
|
S.no |
Description |
|
1 |
Specify the input cell address where you are required to write the formula |
|
|
2 |
Specify the formula string |
|
|
3 |
Specify the Password string if the sheet is password protected |
|
|
4 |
Specify the sheet name in which you are required to write formulae |
|
|
5 |
Displays the action that the activity performs in the workflow |
|
|
6 |
Specify whether to continue executing the workflow even if the activity fails |
|
|
7 |
Define the condition that you prefer to validate. It supports only Boolean value. |
Formula should always be provided as a string variable.
Activity: The WriteCellFormula activity helps you write a formula in a particular cell of a worksheet, which provides the required output when the corresponding inputs are entered.