ListObject.QueryTable Property

 

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

Namespace:   Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

QueryTable QueryTable { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.QueryTable

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

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();
}
Return to top
Show: