XmlMappedRange.QueryTable Property

 

Gets a Microsoft.Office.Interop.Excel.QueryTable that represents the query table that intersects the XmlMappedRange control.

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

A Microsoft.Office.Interop.Excel.QueryTable that represents the query table that intersects the XmlMappedRange control.

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

private void RefreshQueryTable()
{
    this.CustomerLastNameCell.QueryTable.Refresh();
}
Return to top
Show: