Write Cell Formula
This activity is used to apply formula to a specified cell.
Technical Reference:
|
|
INPUT |
Cell: Specify the cell number in which the formula must be written. |
|
Formula: Specify the formula to be applied to the cell. |
||
|
SheetName: Specify the name of the sheet in which the formula must be applied. |
||
|
MISC |
Display Name: Displays the name of the activity. You can also customize the activity name to help troubleshoot issues faster. This name will be used for logging purposes. |
|
|
SkipOnError: It specifies whether to continue executing the workflow even if it throws an error. This supports only Boolean value “True or False.” True: Continues to execute the workflow irrespective of any error thrown. False: Stops the workflow if it throws any error |
||
|
Version: It specifies the version of the excel automation feature in use |
||
|
OUTPUT |
Result: Define a Boolean value to validate the success state of the activity. This is not a mandatory field. |
*Mandatory fields to execute the workflow
The following activity illustrates on how we can use the write cell formula to insert a formula to a specified cell. Here we are going to use a simple formula to sum up the total years of experience of all the employees.
1. Drag and drop a get excel object activity to the workflow.
2. Enter the file path of the excel file in which the worksheet to be worked on is present.
3. Drag and drop a Write cell formula activity into the Get Excel object activity.
4. Click on the write cell formula activity.
5. Enter the cell number in which the formula has to entered. Here it is “D7”
6. Enter the formula to be applied.
7. Enter the name of the sheet in which the formula has to be applied.
8. Execute the activity.
The bot executes the activity, enters the formula given to the specified cell, applies the same to the given cell range and gives the result.