AutoSortField (属性)

返回用于对指定数据透视表字段进行自动排序的数据字段的名称。str 类型，只读。

示例

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

#本示例显示活动工作表的数据透视表中进行自动排序的所有数据字段的名称
def test():
    pvtFields = ActiveSheet.Range("I1").PivotTable.PivotFields()
    for i in range(1, pvtFields.Count):
        print(pvtFields.Item(i).AutoSortField)