PivotFieldOrientation

Enum Class PivotFieldOrientation

java.lang.Object

java.lang.Enum<PivotFieldOrientation>

com.grapecity.documents.excel.PivotFieldOrientation

All Implemented Interfaces:

Serializable, Comparable<PivotFieldOrientation>, Constable

---

public enum PivotFieldOrientation extends Enum<PivotFieldOrientation>

指定数据透视表报表中字段的位置。

将此枚举与 IPivotField.setOrientation(PivotFieldOrientation)一起使用，可以将数据透视字段放置在行区域、列区域、页区域、数据区域，或隐藏该字段。

 Object[][] sourceData = {
     {"Product", "Region", "Amount"},
     {"Apple", "East", 120},
     {"Apple", "West", 80},
     {"Orange", "East", 90}
 };
 worksheet.getRange("A1:C4").setValue(sourceData);
 IPivotCache pivotCache = workbook.getPivotCaches().create(worksheet.getRange("A1:C4"));
 IPivotTable pivotTable = worksheet.getPivotTables().add(pivotCache, worksheet.getRange("E1"), "SalesPivot");
 pivotTable.getPivotFields().get("Region").setOrientation(PivotFieldOrientation.RowField);
 

• 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

  ColumnField

  指定列。

  DataField

  指定数据。

  Hidden

  指定隐藏。

  PageField

  指定页面。

  RowField

  指定行。

• Method Summary

  All MethodsStatic MethodsConcrete Methods

  Modifier and Type

  Method

  Description

  static PivotFieldOrientation

  valueOf(String name)

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

  static PivotFieldOrientation[]

  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

  • Hidden

    public static final PivotFieldOrientation Hidden

    指定隐藏。

  • RowField

    public static final PivotFieldOrientation RowField

    指定行。

  • ColumnField

    public static final PivotFieldOrientation ColumnField

    指定列。

  • PageField

    public static final PivotFieldOrientation PageField

    指定页面。

  • DataField

    public static final PivotFieldOrientation DataField

    指定数据。

• Method Details

  • values

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