Clear Row

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 Row Action?

The Clear Row Action clears one or more rows in an Excel workbook.

Creating a Clear Row 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 Row option, expanding the available Row Options . Choose the desired row option:

  • Current Row- Performs the action to the active row in the workbook
  • Exact Row- Performs the action to a row specified by the user
  • Row Range- Performs the action to a defined  row range

Note: An Exact Row can also be accessed by targeting it directly. For more information about modifying a target column, read the Understanding Excel Targets section of the Understanding Targets article.

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 row is displayed along with a button that allows you to modify the row to target , per the Row Options (above).  (For more information about modifying a target row, read the Understanding Excel Targets section of the Understanding Targets article.)

Select the Clear Row 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 row(s)

  • Formatting - clears any formatting (such as Bold, Italic, and fontsize) present in any of the row(s)

  • Comments - clears any comments that are attached to the row(s)

Optionally add Notes to the Action to document any special instructions or functionality. When the Run Switchis 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.