API Reference
Class
ExcelPivotGroupingInfo
Describes grouping metadata read from a pivot cache field.
Inheritance
- Object
- ExcelPivotGroupingInfo
Usage
Explore 2 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by 1
- Property ExcelPivotTableInfo.Groupings
Accepted by parameters 1
- Constructor ExcelPivotTableInfo.ExcelPivotTableInfo
Constructors
public ExcelPivotGroupingInfo(String fieldName, ExcelPivotGroupBy? groupBy, DateTime? startDate, DateTime? endDate, Double? startNumber, Double? endNumber, Double? interval, Boolean? autoStart, Boolean? autoEnd, IReadOnlyList<String>? groupItems = null, UInt32? baseFieldIndex = null, UInt32? parentFieldIndex = null) #Creates pivot grouping readback information.
Parameters
- fieldName System.String
- groupBy OfficeIMO.Excel.ExcelPivotGroupBy?
- startDate System.DateTime?
- endDate System.DateTime?
- startNumber System.Double?
- endNumber System.Double?
- interval System.Double?
- autoStart System.Boolean?
- autoEnd System.Boolean?
- groupItems System.Collections.Generic.IReadOnlyList<System.String>? = null
- baseFieldIndex System.UInt32? = null
- parentFieldIndex System.UInt32? = null
Inherited Methods
public virtual Boolean Equals(Object? obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object?
Properties
public DateTime? StartDate { get; } #Gets the date grouping start, if present.
public DateTime? EndDate { get; } #Gets the date grouping end, if present.
public Double? StartNumber { get; } #Gets the numeric grouping start, if present.
public Double? EndNumber { get; } #Gets the numeric grouping end, if present.
public Double? Interval { get; } #Gets the grouping interval, if present.
public Boolean? AutoStart { get; } #Gets whether Excel should infer the grouping start.
public Boolean? AutoEnd { get; } #Gets whether Excel should infer the grouping end.
public IReadOnlyList<String> GroupItems { get; } #Gets explicit grouping item labels or values, if present.
public UInt32? BaseFieldIndex { get; } #Gets the source field index used as the base for this grouping, if present.
public UInt32? ParentFieldIndex { get; } #Gets the parent grouping field index, if present.