WinActor

2021.08.02
Libraries
ExcelOperation_SortRange

Sort a selected range in the Excel file.

* Only A1 style is available for specifying a range of cells.
* The range is not selected here. One sort key can be specified.

Please see this precautions upon downloading this library.
Input
"Filename":
Specify an Excel file in an absolute or relative path.

"Sheet_name":
Specify a name of a sheet. When omitted, the active sheet will be used.

"Start_cell":
Specify a start cell position in A1 style.

"End_cell":
Specify an end cell position in A1 style.

"Sort_key_position":
Specify a cell position of a sort key.

Example) C1

"Sort_order":
Specify a sort order.
1: Ascending
2: Descending

"Include_header":
Specify whether the first row is a header or data.
0: Automatically decided by Excel
1: The first row is a header. It is excluded from sorting.
2: The first row is data. It is included for sorting.
Output
Excel file with sorted cells
Details
[History]
2021/08/02: Initial release
Operating environment
WinActor Ver.6.1.0, Windows10(checked on July, 2021)
Keywords
-