Dela via


XmlMappedRange.QueryTable Property (2007 System)

Gets a QueryTable that represents the query table that intersects the XmlMappedRange control.

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

Syntax

'Declaration
<BrowsableAttribute(False)> _
Public ReadOnly Property QueryTable As QueryTable
'Usage
Dim instance As XmlMappedRange 
Dim value As QueryTable 

value = instance.QueryTable
[BrowsableAttribute(false)]
public QueryTable QueryTable { get; }
[BrowsableAttribute(false)]
public:
property QueryTable^ QueryTable {
    QueryTable^ get ();
}
public function get QueryTable () : QueryTable

Property Value

Type: QueryTable
A QueryTable that represents the query table that intersects the XmlMappedRange control.

Examples

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 Sub RefreshQueryTable()
    Me.CustomerLastNameCell.QueryTable.Refresh()
End Sub
private void RefreshQueryTable()
{
    this.CustomerLastNameCell.QueryTable.Refresh(missing);
}

.NET Framework Security

See Also

Reference

XmlMappedRange Class

XmlMappedRange Members

Microsoft.Office.Tools.Excel Namespace