Compartilhar via


PivotField.DrillTo Method

The DrillTo method supports drilling to a specified PivotField from another PivotField.

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

Syntax

'Declaration
Sub DrillTo ( _
    Field As String _
)
'Usage
Dim instance As PivotField
Dim Field As String

instance.DrillTo(Field)
void DrillTo(
    string Field
)

Parameters

Remarks

This operation can only be performed on fields that are actually on the PivotTable. So either a hierarchy containing the requested PivotField has to be in rows or columns of the PivotTable, or the attribute/relational field has to be in rows or columns of the PivotTable placed next to at least one other attribute/relational field. Also, the field being drilled to has to be in the same hierarchy or attribute chain. If these conditions are not met, a run-time error occurs.

See Also

Reference

PivotField Interface

PivotField Members

Microsoft.Office.Interop.Excel Namespace