Sort Range Workbook (preview)

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

UiPath.Excel.Activities.SortRange

説明

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

注:

This activity does not support .xls files.

プロジェクトの対応 OS

Windows | クロスプラットフォーム

プロパティ

共通

• 表示名 - デザイナー パネルに表示されるアクティビティの名前です。

入力

• ファイル - リソースのブックのフル パスです。ローカル パスに切り替えるには、プラス記号のアイコンを選択し、[ローカル ファイルを使用] を選択します。現在のフィールドが [ファイル (ローカル パス)] に変更され、ブックのフル パスを指定できます。
• シート名 - ブックのシートの名前です。
• 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.

オプション

• 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.
• パスワード - ブックのパスワードです (必要な場合)。

ブックを使用する

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

備考

• 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.