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