Clear Column
This article provides information on the following topics:
Note: The Actions Quick Reference provides a complete list of actions that you can print for easy reference.
What is the Clear Column Action?
The Clear Column Action clears one or more columns in an Excel workbook.
Creating a Clear Column Action
Drag and drop the Target Selector
onto the Targets 
list in the target workbook to display the available target options. Continue
to drag the Target Selector to the Column option,
expanding the available Column Options
. Choose the desired column
option:
- Current Column - Performs the action to the active column in the workbook
- Exact Column - Performs the action to a column specified by the user
- Column Range - Performs the action
to a defined range of columns
Note: An Exact Column can also be accessed by targeting it directly.
If this is the first time the workbook was targeted, Nintex RPA LE will attempt to create a workbook connection automatically. (For more information about Microsoft Excel workbook connections, read the Excel Connections article.)
A preview of the Target
Column 
is displayed along
with a button that allows you to modify
the column to target 
.
(For more information about modifying a target column, read the
Understanding
Excel Targets section of the Understanding
Targets article.)
Select the Clear
Column Action 
from the Actions list.
Select the Rules
to change the Connection for this Action. Both
the Timing 
and
Error 
settings
for this action may be configured to fine tune the how the Action will
run.
Note: For more information about the timing and error settings, go to Action Builder.
Select what should be cleared 
in the target column. The following options are available and at least
one must be selected. More than one can be selected as well.
-
Content - clears the data from the column(s)
-
Formatting - clears any formatting (such as Bold, Italic, and fontsize) present in any of the column(s)
-
Comments - clears any comments that are attached to the column(s)
Optionally add Notes
to the Action to document any special instructions
or functionality. When the Run Switch
is set to Run, the action
will be executed after clicking OK.
Note: The run switch is set to Run by default. To create or modify this action without executing it, click the slider to change the option to Don't Run. For more information, go to Action Builder.
Click the OK
button 
to
save the Action.