Partager via

PivotField.AutoShow Method

  • Article

Displays the number of top or bottom items for a row, page, or column field in the specified PivotTable report.

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

Syntax

'Declaration
Sub AutoShow ( _
    Type As Integer, _
    Range As Integer, _
    Count As Integer, _
    Field As String _
)
'Usage
Dim instance As PivotField
Dim Type As Integer
Dim Range As Integer
Dim Count As Integer
Dim Field As String

instance.AutoShow(Type, Range, Count, Field)

void AutoShow(
    int Type,
    int Range,
    int Count,
    string Field
)

Parameters

  • Type
    Type: System.Int32

    Required Integer. Use xlAutomatic to cause the specified PivotTable report to show the items that match the specified criteria. Use xlManual to disable this feature.

  • Range
    Type: System.Int32

    Required Integer. The location at which to start showing items. Can be either of the following constants: xlTop or xlBottom.

  • Count
    Type: System.Int32

    Required Integer. The number of items to be shown.

  • Field
    Type: System.String

    Required String. The name of the base data field. You must specify the unique name (as returned from the SourceName property) and not the displayed name.

See Also

Reference

PivotField Interface

PivotField Members

Microsoft.Office.Interop.Excel Namespace