Sort Worksheet
Activity sorts an Excel worksheet.
Fill in Sort By Column to choose a column and Sort Order to specify if you want the worksheet to be sorted Ascending or Descending.
Optionally specify with Headline Row, if first row is meant to be treated as column headers and ignored (default is False)
| 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 |