Microsoft Office.Excel
Description
Sorts a range or table by first column.
Properties
Analyst
- Display Name: Optional friendly name used for debugging, validation, exception handling, and activity tracking.
- Description: Optional text for documentation purposes.
Common
-
Continue On Error: Continues the execution of the workflow even if an error occurs during the execution of the activity.
-
Delay Before: Delay time in milliseconds before the activity is executed. The default value is 250 milliseconds.
-
Delay After: Delay time in milliseconds after executing of the activity. The default value is 250 milliseconds.
-
Disable Log: Disables the logging functionality for this activity.
-
Disable Protocol: Disables the protocol functionality for this activity.
-
Exclude from Global Delay: Excludes this activity from the Global Delay functionality.
-
Timeout: Duration in milliseconds in which the activity tries to execute.
Input
- Range: The range to be sorted, for example A1:B1. Alternatively, define a table name in the Table property.
- Sheet Name: Name of the sheet where the table is located.
- Table Name: Name of the table to be sorted. Alternatively, define a range in the Range property.
Options
- Sort Order: Order of the sorted range.
- Table Has Header: Select this option if the table has header row. This option is ignored if you are sorting a range.