Export (0) Print
Expand All
Expand Minimize

XmlMappedRange.Group Method

When the XmlMappedRange control represents a single cell in the data range of a PivotTable field, the Group method performs numeric or date-based grouping in that field.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Object Group(
	Object Start,
	Object End,
	Object By,
	Object Periods
)

Parameters

Start
Type: System.Object

The first value to be grouped. If this argument is omitted or true, the first value in the field is used.

End
Type: System.Object

The last value to be grouped. If this argument is omitted or true, the last value in the field is used.

By
Type: System.Object

If the field is numeric, this argument specifies the size of each group. If the field is a date, this argument specifies the number of days in each group if element 4 in the Periods array is true and all the other elements are false. Otherwise, this argument is ignored. If this argument is omitted, Microsoft Office Excel automatically chooses a default group size.

Periods
Type: System.Object

An array of seven Boolean values that specify the period for the group, as shown:

1 - Seconds

2 - Minutes

3 - Hours

4 - Days

5 - Months

6 - Quarters

7 - Years

If an element in the array is true, a group is created for the corresponding time; if the element is false, no group is created. If the field is not a date field, this argument is ignored.

Return Value

Type: System.Object

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Show:
© 2015 Microsoft