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 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 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.

    Note: If you place this activity inside a For Each Excel Row activity, make sure that the target range of rows is not the same as the target range of the For Each Excel Row activity. This aims to avoid issues where unintended rows in the iteration would get deleted.

Properties Panel

Common

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

Input

• Source range - See In what table or range in the body of the activity.
• What to delete - See What to delete in the body of the activity.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

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.