跳到主要内容

SortOrder

指定排序顺序。

类型​

枚举

值​

  • "xlAscending"
  • "xlDescending"

示例​

指定 “A1:A5” 中指定值的排序顺序为升序。

// How do I set the sort order (ascending or descending) for each range?

// Sort a range of cells indicating sorting orders for sub ranges.

worksheet.GetRange("A1:C5").SetSort("A1:A5", "xlAscending", "B1:B5", "xlDescending", "C1:C5", "xlAscending", "xlYes", "xlSortColumns");