PivotFieldRepeatLabels

Enum Class PivotFieldRepeatLabels

java.lang.Object

java.lang.Enum<PivotFieldRepeatLabels>

com.grapecity.documents.excel.PivotFieldRepeatLabels

All Implemented Interfaces:

Serializable, Comparable<PivotFieldRepeatLabels>, Constable

---

public enum PivotFieldRepeatLabels extends Enum<PivotFieldRepeatLabels>

指定是否在数据透视表报表中重复项标签。

将此枚举与 IPivotTable.repeatAllLabels(PivotFieldRepeatLabels)一起使用，可以控制是否在每一行显示重复的行字段项，或仅显示一次。

 worksheet.getRange("A1:C5").setValue(new Object[][] {
     {"Category", "Product", "Amount"},
     {"Beverages", "Tea", 100},
     {"Beverages", "Coffee", 200},
     {"Snacks", "Chips", 150},
     {"Snacks", "Nuts", 120}
 });
 IPivotCache pivotCache = workbook.getPivotCaches().create(worksheet.getRange("A1:C5"));
 IPivotTable pivotTable = worksheet.getPivotTables().add(pivotCache, worksheet.getRange("E1"), "SalesPivot");
 pivotTable.repeatAllLabels(PivotFieldRepeatLabels.RepeatLabels);
 

• Nested Class Summary

  Nested classes/interfaces inherited from class java.lang.Enum

  Enum.EnumDesc<E extends Enum<E>>

• Enum Constant Summary

  Enum Constants

  Enum Constant

  Description

  DoNotRepeatLabels

  不要重复项目标签。

  RepeatLabels

  重复所有项目标签。

• Method Summary

  All MethodsStatic MethodsConcrete Methods

  Modifier and Type

  Method

  Description

  static PivotFieldRepeatLabels

  valueOf(String name)

  Returns the enum constant of this class with the specified name.

  static PivotFieldRepeatLabels[]

  values()

  Returns an array containing the constants of this enum class, in the order they are declared.

  Methods inherited from class java.lang.Enum

  clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

  Methods inherited from class java.lang.Object

  getClass, notify, notifyAll, wait, wait, wait

• Enum Constant Details

  • DoNotRepeatLabels

    public static final PivotFieldRepeatLabels DoNotRepeatLabels

    不要重复项目标签。

  • RepeatLabels

    public static final PivotFieldRepeatLabels RepeatLabels

    重复所有项目标签。

• Method Details

  • values

    public static PivotFieldRepeatLabels[] 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 PivotFieldRepeatLabels 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