Sort Range

UiPath.Excel.Activities.Business.SortX

Description

Classifica em uma ou mais colunas os dados de uma tabela, planilha ou intervalo especificado. A atividade pode ser usada com um arquivo Excel selecionado para uma atividade Use Excel File pai ou com o Project Notebook.

Configurando a atividade

Painel do Designer

• Range - Select Plus on the right side of the field, then, from the menu, select the file and then a sheet, table, or range to sort, or select Indicate in Excel to indicate a range directly from the file. Alternatively, you can select Custom Input to enter a range, table name, or sheet name manually, or Open in Advanced Editor to enter a VB expression. The first row in the specified range is treated as a header row, which means the data is always sorted starting with the second row.
• Add sort column - Select this button to add a column to sort by. If multiple sort columns are added, the order in which the columns are placed determines the order in which the data is sorted.

Classificar por opções de coluna

• Column - Select Plus on the right side of the field, and then select Range and the column to sort by. You can specify the column by selecting one of the values in the first row of the selected range from the menu, or by clicking Indicate in Excel and selecting any cell from the column directly from the file. Alternatively, you can use one of the other options in the menu to indicate the value form the cell in the first row of the column to sort by:

  • Selecione o arquivo do Excel e, então, indique a célula na primeira linha da coluna pela qual classificar.
  • Use Saved Value - Select a value that you previously saved for later use in the project.
  • Texto - Insira um valor no Construtor de Texto.
  • Perguntar quando executar - Solicite o valor quando o projeto é executado.
  • Open in Advanced Editor - Enter a VB expression.

• Direction - Select the direction of the sort from the drop-down menu: Ascending or Descending.

Painel de Propriedades

Comum

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

Entrada

• Intervalo - Consulte Intervalo no corpo da atividade.

Diversos

• Particular — se selecionada, os valores de variáveis e argumentos não são mais registrados no nível Verbose.