AutoSortOrder (属性)

返回用于对指定数据透视表字段进行自动排序的次序。可为 XlSortOrder 常量之一。int 类型，只读。

示例

python

#本示例在消息框中显示“grades”字段的 AutoSort 参数值
def test():
    pvtField = Worksheets.Item(1).PivotTables(1).PivotFields("grades")
    aso = None

    if pvtField.AutoSortOrder == xlManual:
        aso = "manual"
    elif pvtField.AutoSortOrder == xlAscending:
        aso = "ascending"
    elif pvtField.AutoSortOrder == xlDescending:
        aso = "descending"

    print(" sorted in " + aso + " order by " + pvtField.AutoSortField)

python

#本示例显示活动工作表中数据透视表是否按降序对字段“age”排序
def test():
    pvtField = ActiveSheet.Range("I1").PivotTable.PivotFields("age")
    print(pvtField.AutoSortOrder == xlDescending)