編輯

共用方式為


_QueryTable.Sort Property

Definition

Returns the sort criteria for the query table range. Read-only.

public:
 property Microsoft::Office::Interop::Excel::Sort ^ Sort { Microsoft::Office::Interop::Excel::Sort ^ get(); };
public Microsoft.Office.Interop.Excel.Sort Sort { get; }
Public ReadOnly Property Sort As Sort

Property Value

Sort

Remarks

If you import data using the user interface, data from Web queries or text queries is imported as a _QueryTable object, while all other external data is imported as a ListObject object.

If you import data using the object model, data from Web queries or text queries must be imported as a QueryTable, while all other external data can be imported as either a ListObject or a QueryTable.

You can use the QueryTable property of the ListObject to access the Sort property.

Applies to