Activities
latest
false
Delete Range - Other latest
logo
Productivity Activities
Last updated Dec 6, 2023

Delete Range

UiPath.Excel.Activities.ExcelDeleteRange

Deletes a specified range in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property fields.

Properties

Common

  • DisplayName - The display name of the activity.

Input

  • Range - The range you want to delete. This field supports only strings and String variables.
  • SheetName - The name of the sheet you want to create the workbook from. This field supports only strings and String variables.

Misc

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

Options

  • ShiftCells - If this box is cleared, only the cell data is deleted, leaving the formatting unmodified. If selected, cell formatting is shifted according to what is specified in the ShiftOption property. By default, this check box is cleared.
  • ShiftOption - Specifies how to shift the cells in the deleted range. The available options are ShiftUp, ShiftDown, EntireRow, and EntireColumn.

Example of Using the Delete Range Activity

To exemplify how to use this activity, we have built an automation project which deletes a range in an Excel workbook.

Download example

  • Properties
  • Example of Using the Delete Range Activity
logo
Get The Help You Need
logo
Learning RPA - Automation Courses
logo
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2023 UiPath. All rights reserved.