UiPath.Excel.Activities.Business.DeleteRowsX

📘

Note:

This activity was first introduced in the UiPath.Excel.Activities v2.8.0-preview activities package.

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.

In the Body of the Activity

• In what table or range - Click 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 from the drop-down list the type of delete to perform:
  • Specific rows - Specify which rows to delete using one of the options in the 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.

Properties

Common

• Display Name - 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 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.
• HasHeaders - If selected, the first row in the range is not deleted when the option All visible rows is selected for What to delete.