Delete Columns
You can select this activity to delete a specific column from a sheet. The column on the right of the deleted column shifts to the left.
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 columns A:F, and you specify A:B, then the columns A:B are deleted. The data in columns C:F are then shifted according to your specified Shift value. |
Workbook | OnedriveItem | The file or document stored in OneDrive from which columns 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 from which columns must be deleted. | |
Misc | Display Name | <String> | The name to be dis- played for the activity. |
Output | Response Code | Int32 | Response code for the activity. Possible values:
|