Insert Rows
This action is used to add a number of rows in an excel document.
Properties
Input
Excel Document: File name for the target Excel document.
WorkSheet: The target worksheet name.
Target Row: The target cell. Rows will be inserted above the selected row.
Row Count: The number of rows to insert (default is 1).
Target Row: This needs to be a cell (A1) and not a range (A1:C5).
Misc
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.
Use Case
Potential Use Cases
Changing the format of the file by adding rows in it.
Examples of Using Insert Rows
Example
Watch the robot in action:
You can check and download the example from here:
Last updated