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)

Syntax

'Declaration
ReadOnly Property QueryTable As QueryTable
    Get

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.

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 Sub ListObject_QueryTable()
        Me.customerListObject.QueryTable.Refresh()
    End Sub

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

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

ListObject Interface

Microsoft.Office.Tools.Excel Namespace