Megosztás a következőn keresztül:


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)

Syntax

'Declaration
ReadOnly Property QueryTable As QueryTable
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.

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();
}

.NET Framework Security

See Also

Reference

XmlMappedRange Interface

Microsoft.Office.Tools.Excel Namespace