Sorts a table from a spreadsheet based on the values of a column. The table can only be sorted ascending or descending. Can only be used in the Excel Application Scope activity.
Strings must be placed between quotation marks.
TableName - The name of the table to be sorted. Only String variables and strings are supported.
ColumnName - The name of the column that you want to sort. Only String variables and strings are supported.
Order - The order in which to sort the specified column. The following options are available: Ascending - order from smallest to biggest (numbers) or from A to Z (alphabetic characters). Descending - order from biggest to smallest (numbers) or from Z to A (alphabetic characters).
- SheetName - The name of the sheet where the table to be sorted is found. By default, this is filled in with "Sheet1." Only String variables and strings are supported.
- DisplayName - The display name of the activity.
- Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
You can see how the Sort Table activity is used in an example that incorporates multiple activities.
To exemplify how to use this activity, we have built an automation project which also includes a Sort Table activity.
You can check and download the example from here
Updated 7 months ago