Manage Row
Activity adds or deletes a row in an Excel worksheet.
Fill out the Row parameter and choose between Insert Empty and Delete.
Insert Empty inserts an empty row above the chosen one (chosen Row and everything following it will be moved down).
Delete deletes chosen Row, moving all the rows following it up.
| Name | Type | Category | Description |
|---|---|---|---|
| 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) |
| Headline Row | Boolean | Input | expression; default is "false". Set to true, if the first row of the worksheet contains column names |
| Sort By Column | Int32 | Input | column number in Excel to sort worksheet by |
| Sort Order | Dropdown | Input | select sort order from the dropdown list |
| 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 |
| Exclude from Transaction Check | Boolean | Misc | checkbox; default is "off" |
| 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 |