Subscribe

UiPath Activities

The UiPath Activities Guide

Clear Sheet/Range/Table

UiPath.Excel.Activities.Business.ClearRangeX

Clears the data from a specified sheet, range, or table. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook.

Configuring the Activity

In the Body of the Activity

  • Range to clear - Click Plus plus buttonplus button on the right side of the field, then, from the menu, select the file and then a sheet, table, or range to clear, or select Indicate in Excel to indicate a range directly from the file. Alternatively, you can select Custom Input to enter the range manually, or Open in Advanced Editor to enter a VB expression.
  • Has headers - If selected, it indicates that the first row in the defined range is a header row and should not be cleared of data. This option is not selected by default.

In the Properties Panel

Common

  • DisplayName - The name displayed for the activity in the Designer panel.

Input

Misc

  • Private - If selected, the data used in the activity is not logged by StudioX.

Options

Updated 29 days ago


Clear Sheet/Range/Table


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.