Delete Columns

This action is used to delete a range of columns.

Properties

Input

• Excel Document: File name for the target Excel document.

• WorkSheet: The target worksheet name.

• Cell Range: The target range marked for deletion.

The range needs to be specified as an A1 notation. For example "A1:E1" marks five columns for deletion.

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

• Delete columns containing irrelevant data.

• Delete columns based on a filter.

Examples of Using Delete Columns

Example

Watch the robot in action:

You can check and download the example from here:

6KB

Delete Columns.zip

archive