Delete Range
You can select this activity to delete specified cell range from the selected Excel workbook. 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 cells A1:B5, and you specify A1:B3, then the data in cells A1:B3 is deleted. The data in cells A4:B5 are then shifted according to your specified Shift value |
| Workbook | OnedriveItem | The file or document stored in OneDrive from which the specified cell range 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:
|