Udostępnij za pośrednictwem

ListObject.QueryTable Property

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assemblies:
Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Gets the QueryTable that provides a link for the ListObject control to the list server.

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

Property Value

QueryTable

The QueryTable that provides a link for the ListObject control to the list server.

Examples

The following code example uses the QueryTable property to refresh the query table that intersects a ListObject. This code example assumes that the current worksheet contains a ListObject named customerListObject that is intersected by a query table.

This example is for a document-level customization.

private void ListObject_QueryTable()
{
    this.customerListObject.QueryTable.Refresh();
}

Private Sub ListObject_QueryTable()
    Me.customerListObject.QueryTable.Refresh()
End Sub

Applies to