Delete Rows

You can select this activity to delete one or several rows from a specified position in a workbook. When you delete a row, the cells below shift up automatically. This table lists the properties for the activity.

Property Type Property Name Data Type Description
Common Continue on error Boolean Select the check box to continue the RPA flow even if the activity fails. This check box is selected by default.
Input Range String The range of data to be deleted. You must specify the data range in A1- style format. For example, if you have data in rows 1:5, and you specify 1:3, then the data in rows 1:3 is deleted. The data in rows 4:5 are then shifted according to your specified Shift value.
Workbook OnedriveItem The file or document stored in OneDrive from which the specified rows must be deleted.

You can retrieve the metadata of a OneDrive item by using the OneDrive activities for an existing workbook or by using the output from the Create Workbook activity.

Worksheet Name String The name of the worksheet that must be modified.
Misc Display Name <String> The name to be dis- played for the activity.
Output Response Code Int32 Response code for the activity. Possible values:
  • 200 to 290: Indicates a successful response or valid output.
  • 400 to 499: Indicates client error responses.
  • 500 to 599: Indicates server error responses.