Description

Sorts a table on a spreadsheet based on the values of a column in descending or ascending order.



Attributes

Input

  • ColumnName - The name of the column to be sorted.

  • Order - The order of which the column would be sorted. The options are ascending or descending sorting.

  • TableName - The name of the table to be sorted.

  • Worksheet - The name of the sheet to be updated. By default, it is set to “Sheet1”.

Common

  • ContinueOnError - The Boolean value to specify whether to continue executing the next activities even if there is an error thrown on this activity.

Misc

  • DisplayName - Renames the activity.


Example

For this example, this is what the sample Spreadsheet contains:



  1. Add an Excel Sequence activity inside a Sequence.
  2. In the File Path field, search for and select your Spreadsheet document by, first, clicking the browse button.
  3. Add a Sort Table activity, and in the Worksheet field, write "Employees" (or the name of the sheet you would use).
  4. In the Table Name field, write "Info" since this is the name of the table from the sample Spreadsheet.
  5. In the Column Name field, write "Name". This means this table would be sorted based on the values in Column Name.
  6. In the Order field under Properties, choose Descending. 


            The use case should look as the following screenshot:



            After execution, the values of the Spreadsheet should be sorted in descending order based on the values of the Column Name: