Sort Range Workbook (preview)

Sort Range Workbook activity that sorts the data in a range by one or more columns.

UiPath.Excel.Activities.SortRange

Description

Sorts the data in a range by one or more columns. This is the cross-platform equivalent of the Sort Range Windows activity.

Observação:

This activity does not support .xls files.

Compatibilidade do projeto

Windows | Multiplataforma

Propriedades

Comum

• DisplayName - The name displayed for the activity in the Designer panel.

Entrada

• Arquivo - O caminho completo da pasta de trabalho do recurso. Para alternar para um caminho local, selecione o ícone de mais e, em seguida, Usar arquivo local. O campo atual muda para File (caminho local), onde você pode fornecer o caminho completo da pasta de trabalho.
• NomeDaPlanilha - O nome da planilha da pasta de trabalho.
• Range - The range to sort, in the A1:B10 format. This field is required.
• Sort Columns - The columns to sort by, in priority order. You can use a list, an array, or any sequence. This field is required. Each entry has the following members:
  • ColumnName - The column to sort by. Enter its header name when Has Headers is selected, or its letter otherwise, for example, "B".
  • Order - The sort direction, Ascending or Descending. The default value is Ascending.

Opções

• Has Headers - Select this option to treat the first row of the range as a header row and exclude it from the sort. By default, this option is selected.
• Senha - A senha da pasta de trabalho, se necessário.

Usar pasta de trabalho

• Workbook - The existing workbook to use instead of a file path.

Observações

• When Has Headers is selected, ColumnName must match a header exactly. It is never read as a column letter in that case. When Has Headers is not selected, ColumnName must be a column letter inside the range.
• The header row stays in place and is not sorted.
• A whole-column or whole-row range, such as A:C, is limited to the used range of the sheet.
• Range must refer to the sheet in SheetName. A range that includes a sheet name, such as Sheet2!A1:C10, is not supported and causes an error.
• The activity fails with an error in the following cases:
  • Range or Sort Columns is empty.
  • Sort Columns contains an empty entry, or an entry without a ColumnName.
  • Has Headers is selected and a ColumnName doesn't match any header.
  • Has Headers is not selected and a ColumnName is a column letter outside the range.