Partager via


PivotTable.PivotSelection Property

Returns or sets the PivotTable selection in standard PivotTable report selection format. Read/write String.

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

Syntax

'Declaration
Property PivotSelection As String
    Get
    Set
'Usage
Dim instance As PivotTable
Dim value As String

value = instance.PivotSelection

instance.PivotSelection = value
string PivotSelection { get; set; }

Property Value

Type: System.String

Remarks

Setting this property is equivalent to calling the PivotSelect method with the Mode argument set to xlDataAndLabel.

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace