PivotTableSetManualGroupField Method (Int32, DateTime, DateTime, ArrayList, Int32)

Sets manual field group by the PivotTable.

Namespace:  Aspose.Cells.Pivot
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 20.9.0.0 (20.9)
Syntax
public void SetManualGroupField(
	int baseFieldIndex,
	DateTime startVal,
	DateTime endVal,
	ArrayList groupByList,
	int intervalNum
)

Parameters

baseFieldIndex
Type: SystemInt32
The row or column field index in the base fields
startVal
Type: SystemDateTime
Specifies the starting value for date grouping.
endVal
Type: SystemDateTime
Specifies the ending value for date grouping.
groupByList
Type: System.CollectionsArrayList
Specifies the grouping type list. Specified by PivotTableGroupType
intervalNum
Type: SystemInt32
Specifies the interval number group by in days grouping.The number of days must be positive integer of nonzero
See Also