Excel Sorting ​

Function Description ​

TIP

Perform ascending, descending, or custom sort on specified columns in Excel

Excel Sorting

Configuration Item Description ​

General ​

Command Input

  • Excel InstanceTWorkbookApplication: Input an Excel instance obtained through 'Open or Create Excel'/'Get currently active Excel instance' function

  • Sort MethodInteger: Select the sort method

  • Sort Columnstring: Enter the column name (supports A or 1), use A,B,C or A:C for multiple columns, -N represents the nth to last column

  • Expand Selected RangeBoolean: Expand Selected Range

  • Exclude First Row from SortBoolean: If checked, the first row will not be included in the sort

  • Custom Liststring: Custom sequence, such as: Sun, Mon, Tue, Wed, Thu, Fri, Sat

  • Custom Sort Columnstring: Enter the column name (supports A or 1), use A,B,C or A:C for multiple columns, -N represents the nth to last column

  • Region TypeInteger: Select the sort region type

  • Start Row NumberInteger: Row number. Starts from 1

  • Start Column Namestring: Column name. Starts with A

  • End Row NumberInteger: Row number. Starts from 1

  • End Column Namestring: Column name. Starts with A

  • Row NumberInteger: Row number. Starts from 1

  • Column Namestring: Column name. Starts with A

  • Sheet Namestring: Worksheet name

Command Output

No output for the current command

Advanced ​

  • Delay Before(milliseconds)Integer: The waiting time before instruction execution

Error Handling ​

  • Print Error LogsBoolean: Whether to print error logs to the "Logs" panel when the command fails. Default is checked.

  • Handling MethodInteger:

    • Terminate Process: If the command fails, terminate the process.

    • Ignore Exception and Continue Execution: If the command fails, ignore the exception and continue the process.

    • Retry This Command: If the command fails, retry the command a specified number of times with a specified interval between retries.

Usage Example ​

Process logic description:

Common Errors and Handling ​

None

Frequently Asked Questions ​

None