Microsoft Excel

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)

sortworksheets1
sortworksheets2
Parameter NameParameter TypeIn/OutDescription
Alternative Scenario If FailedBooleanInputcheckbox; default is "on"
Display NameLiteralInputchanges display name of the activity
Exclude from Transaction CheckBooleanInputcheckbox; default is "off"
Retry Timeout [s]DoubleInputdetermines 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 NameStringInputcustom internal name Wizlink will use to identify the workbook
Worksheet NameStringInputname of the Excel sheet
Sort By ColumnInt32Inputnumber of Excel column to sort by (column numbers start from 1)
Headline RowBooleanInputare there column labels in the first row; default is "false"
Sort OrderDropdownInputsort ascending or descending
ResultBooleanOutputreturns a Boolean value. True if no error in activity, otherwise will return False
Result CodeInt32OutputResult Code will return 0 if there is no error in activity, otherwise in most cases it will return 1, the extended result code will show only in several chosen activities