Manage Column
Activity adds or deletes a row in an Excel worksheet.
Fill out the Column parameter and choose between Insert Empty and Delete.
Insert Empty inserts an empty column to the left of the chosen one (chosen Column and everything following it will be moved to the right).
Delete deletes chosen Column, moving all the columns following left.
| Name | Type | Category | Description |
|---|---|---|---|
| Action | Dropdown | Input | select action to perform from the dropdown list |
| Column | Int32 | Input | column number in Excel |
| Retry Timeout [s] | Double | Input | determines behaviour if the activity fails to execute. value < 0: try executing once, 0: try indefinitely; value >0: time in seconds during which the activity repeatedly tries to execute (if time elapses without success then Result = False, end activity) |
| Workbook Name | String | Input | custom internal name Wizlink will use to identify the workbook |
| Worksheet Name | String | Input | name of the Excel sheet |
| Alternative Scenario If Failed | Boolean | Misc | checkbox; default is "on" |
| Display Name | Literal | Misc | changes display name of the activity |
| Result | Boolean | Output | returns a Boolean value. True if no error in activity, otherwise will return False |
| Result Code | Int32 | Output | Result Code will return 0 if there is no error in activity, otherwise in most cases will return 1. See the table of Extended Result Codes for more info |
| Fullscreen | Boolean | Screenshot | checkbox; default is "off" |
| Screenshot Path | String | Screenshot | directory path to save location |
| Show Cursor | Boolean | Screenshot | checkbox; default is "off" |
| Window Screenshots | Boolean | Screenshot | checkbox; default is "off" |