Class PivotPageFields
Namespace: Aspose.Cells.Pivot
Assembly: Aspose.Cells.dll (25.2.0)
Represents the pivot page field items if the pivot table data source is consolidation ranges. It only can contain up to 4 fields.
public class PivotPageFieldsInheritance
Inherited Members
object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Constructors
PivotPageFields()
Represents the pivot page field items.
public PivotPageFields()Properties
PageFieldCount
Gets the number of page fields.
public int PageFieldCount { get; }Property Value
Methods
AddIdentify(int, int[])
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.
public void AddIdentify(int rangeIndex, int[] pageItemIndex)Parameters
rangeIndex int
The consolidation data range index.
pageItemIndex int[]
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[])
Adds a page field.
public void AddPageField(string[] pageItems)Parameters
pageItems string[]
Page field item label