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