_QueryTable.Sort Property

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

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

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.