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.
| Acquired Text | String | Output | text input by user |
|---|---|---|---|
| Alternative Scenario If Failed | Boolean | Input | checkbox; default is "on" |
| Display Name | Literal | Input | changes display name of the activity |
| Exclude from Transaction Check | Boolean | Input | checkbox; default is "off" |
| 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 |
| Sort Order | Dropdown | Input | select sort order from the dropdown list |
| Sort By Column | Int32 | Input | column number in Excel to sort worksheet by |
| Headline Row | Boolean | Input | expression; default is "false". Set to true, if the first row of the worksheet contains column names |
| 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 |