[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

PivotCellType

Enum Class PivotCellType

java.lang.Object
java.lang.Enum<PivotCellType>
com.grapecity.documents.excel.PivotCellType
All Implemented Interfaces:
Serializable, Comparable<PivotCellType>, Constable
public enum PivotCellType extends Enum<PivotCellType>
Specifies the PivotTable entity the cell corresponds to.

  • Enum Constant Details

    • Value

      public static final PivotCellType Value
      Any cell in the data area (except a blank row).

    • PivotItem

      public static final PivotCellType PivotItem
      A cell in the row or column area which is not a subtotal, grand total, custom subtotal, or blank line.

    • Subtotal

      public static final PivotCellType Subtotal
      A cell in the row or column area which is a subtotal.

    • GrandTotal

      public static final PivotCellType GrandTotal
      A cell in a row or column area which is a grand total.

    • DataField

      public static final PivotCellType DataField
      A data field label (not the Data button).

    • PivotField

      public static final PivotCellType PivotField
      The button for a field (not the Data button).

    • PageFieldItem

      public static final PivotCellType PageFieldItem
      The cell that shows the selected item of a Page field.

    • CustomSubtotal

      public static final PivotCellType CustomSubtotal
      A cell in the row or column area that is a custom subtotal.

    • DataPivotField

      public static final PivotCellType DataPivotField
      The Data button.

    • BlankCell

      public static final PivotCellType BlankCell
      A structural blank cell in the PivotTable.

  • Method Details

    • values

      public static PivotCellType[] values()
      Returns an array containing the constants of this enum class, in the order they are declared.
      Returns:
      an array containing the constants of this enum class, in the order they are declared

    • valueOf

      public static PivotCellType valueOf(String name)
      Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)
      Parameters:
      name - the name of the enum constant to be returned.
      Returns:
      the enum constant with the specified name
      Throws:
      IllegalArgumentException - if this enum class has no constant with the specified name
      NullPointerException - if the argument is null