Delete Range
You can select this activity to delete data from a cell of a specific worksheet. This table lists the properties for the activity.
| Property Type | Property Name | Data Type | Description |
|---|---|---|---|
| Input | Range | String | The range of data to be deleted. You must specify the data range in A1-style notation. 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 ac- cording to your specified Shift value. |
| Shift | N/A | The response of the surrounding cells after a data range has been deleted. You can select one of these options: None: This is the default value. The cells outside of the specified range are unchanged and the deleted range of cells is left blank. Up: The cells below the range are moved up to populate the deleted range of cells. Left: The cells to the right of the range are moved left to populate the deleted range of cells. | |
| Workbook Path | String | The workbook location. | |
| WorkSheet Name | String | The name of the worksheet that must be modified. | |
| Output | Response Code | Int32 | Response code for the activity. Possible values:
|