Fill Rows
Last updated
Last updated
This action is used to fill a range of rows with a target formula.
Excel Document: File name for the target Excel document.
WorkSheet: The target worksheet name.
Cell Range: The target name.
Formula: The formula to be used when filling the rows.
The range needs to be specified as an A1 notation and span a single column. Example "A1:A5".
Display Name: action display name in your implementation project
Wait Before: number milliseconds robot to wait before executing the action.
Wait After: number milliseconds robot to wait until moving to the next action.
Abort on Error: True/False
Retry Times: Specifies the number of times to retry an action if it doesn't end successfully. Default value 0 (no retry); Use -1 if you want to retry indefinitely.
Fill rows with a formula to calculate their sum.
Fill rows with a formula to calculate their division.
Fill rows with a formula to calculate their subtraction.
Example
Watch the robot in action:
You can check and download the example from here: