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 | Description |
---|---|---|
Input | Range | 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 according to your specified Shift value. |
Shift | 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 | The workbook location. | |
WorkSheet Name | The name of the worksheet that must be modified. | |
Output | Response Code | Response code for the activity. Possible values:
|