編輯

共用方式為


SortField Interface

Definition

The SortField object contains all the sort information for the Worksheet, ListObject, and AutoFilter objects.

public interface class SortField
[System.Runtime.InteropServices.Guid("000244A9-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface SortField
Public Interface SortField
Attributes

Properties

Application

When used without an object qualifier, this property returns an _Application object that represents the Microsoft Office Excel application. When used with an object qualifier, this property returns an _Application object that represents the creator of the specified object. Read-only.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only.

CustomOrder

Specifies a custom order to sort the fields. Read/write.

DataOption

Specifies how to sort text in the range specified in SortField object. Read/write.

Key

Specifies the range that is currently being sorted on. Read-only.

Order

Determines the sort order for the values specified in the key. Read/write.

Parent

Returns the parent object for the specified object. Read-only.

Priority

Specifies the priority for the sort field. Read/write.

SortOn

Returns or sets what attribute of the cell to sort on . Read/write.

SortOnValue

Retun the value on which the sort is performed for the specified SortField object. Read-only.

Methods

Delete()

Removes the specified SortField object from the SortFields collection.

ModifyKey(Range)

Modify the key value by which values are sorted in the field.

SetIcon(Icon)

Sets an icon for a SortField object.

Applies to