PivotPageFields

Inheritance: java.lang.Object

public class PivotPageFields

Represents the pivot page field items if the pivot table data source is consolidation ranges. It only can contain up to 4 fields.

Constructors

ConstructorDescription
PivotPageFields()Represents the pivot page field items.

Methods

MethodDescription
addIdentify(int rangeIndex, int[] pageItemIndex)Sets which item label in each page field to use to identify the data range.
addPageField(String[] pageItems)Adds a page field.
equals(Object arg0)
getClass()
getPageFieldCount()Gets the number of page fields.
hashCode()
notify()
notifyAll()
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

PivotPageFields()

public PivotPageFields()

Represents the pivot page field items.

addIdentify(int rangeIndex, int[] pageItemIndex)

public void addIdentify(int rangeIndex, int[] pageItemIndex)

Sets which item label in each page field to use to identify the data range. The pageItemIndex.Length must be equal to PageFieldCount, so please add the page field first.

Parameters:

ParameterTypeDescription
rangeIndexintThe consolidation data range index.
pageItemIndexint[]The page item index in the each page field. pageItemIndex[2] = 1 means the second item in the third field to use to identify this range. pageItemIndex[1] = -1 means no item in the second field to use to identify this range and MS will auto create “blank” item in the second field to identify this range.

addPageField(String[] pageItems)

public void addPageField(String[] pageItems)

Adds a page field.

Parameters:

ParameterTypeDescription
pageItemsjava.lang.String[]Page field item label

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

getPageFieldCount()

public int getPageFieldCount()

Gets the number of page fields.

Returns: int

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int