Insert Columns
This action is used to add a number of columns in an excel document.
Properties
Input
Excel Document: File name for the target Excel document.
WorkSheet: The target worksheet name.
Target Column: The target cell. Columns will be inserted to the left of the specified column.
Column Count: The number of columns to insert (default is 1).
Target Column: 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 columns in it.
Examples of Using Insert Columns
Example
Watch the robot in action:
You can check and download the example from here:
Last updated