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