UiPath Activities

The UiPath Activities Guide

Delete Rows

UiPath.Excel.Activities.Business.DeleteRowsX

Deletes the specified rows from a sheet, table, or range. You can specify individual rows, an interval of rows, delete all visible, hidden, or duplicate rows. 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

  • In what table or range - 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 from which to delete rows, 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.
  • What to delete - Select the rows to delete:
    • Specific rows - Specify which rows to delete using one of the options in the Plus plus buttonplus button menu on the right side of the At position field. Select Text to enter the row numbers in the Text Builder. You can enter one or more row numbers (for example: 7, 9), an interval (for example: 3-5), or a combination of row numbers and intervals (for example: 2, 4-7, 12).
    • All visible rows - Delete all visible rows. If the Has Headers option is selected, the first row in the range is not deleted.
    • All hidden rows - Delete all hidden or filtered rows.
    • All duplicate rows - Delete all duplicate rows.

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

  • At position - Indicate the rows to delete when the option Specific rows is selected for What to delete.
  • Has headers - If selected, the first row in the range is not deleted when the option All visible rows is selected for What to delete.

Updated 3 months ago


Delete Rows


Suggested Edits are limited on API Reference Pages

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