C# Class OfficeOpenXml.Table.PivotTable.ExcelPivotTableField

A pivot table field.

Inheritance: XmlHelper

Show file Open project: pruiz/EPPlus Class Usage Examples

Private Properties

Property	Type	Description
AddCacheField	void
AddDateGroupItems	int
AddDateGrouping	void
AddField	ExcelPivotTableField
AddField	ExcelPivotTableField
AddFieldItems	void
AddGroupItem	void
AddNumericGroupItems	int
AddTimeSerie	void
AppendField	System.Xml.XmlElement
ExcelPivotTableField	System
SetCacheFieldNode	void
SetDateGroup	ExcelPivotTableFieldDateGroup
SetNumericGroup	ExcelPivotTableFieldNumericGroup
ValidateGrouping	void

Public Methods

Method	Description
AddDateGrouping ( eDateGroupBy groupBy ) : void	Add a date grouping on this field.
AddDateGrouping ( eDateGroupBy groupBy, System.DateTime startDate, System.DateTime endDate ) : void	Add a date grouping on this field.
AddDateGrouping ( int days, System.DateTime startDate, System.DateTime endDate ) : void	Add a date grouping on this field.
AddNumericGrouping ( double Start, double End, double Interval ) : void	Add numberic grouping to the field

Private Methods

Method	Description
AddCacheField ( ExcelPivotTableField field, System.DateTime startDate, System.DateTime endDate, int interval ) : void
AddDateGroupItems ( OfficeOpenXml.Table.PivotTable.ExcelPivotTableFieldGroup group, eDateGroupBy GroupBy, System.DateTime StartDate, System.DateTime EndDate, int interval ) : int
AddDateGrouping ( eDateGroupBy groupBy, System.DateTime startDate, System.DateTime endDate, int groupInterval ) : void
AddField ( eDateGroupBy groupBy, System.DateTime startDate, System.DateTime endDate, bool &firstField ) : ExcelPivotTableField
AddField ( eDateGroupBy groupBy, System.DateTime startDate, System.DateTime endDate, bool &firstField, int interval ) : ExcelPivotTableField
AddFieldItems ( int items ) : void
AddGroupItem ( XmlElement groupItems, string value ) : void
AddNumericGroupItems ( OfficeOpenXml.Table.PivotTable.ExcelPivotTableFieldNumericGroup group, double start, double end, double interval ) : int
AddTimeSerie ( int count, XmlElement groupItems ) : void
AppendField ( XmlNode rowsNode, int index, string fieldNodeText, string indexAttrText ) : XmlElement
ExcelPivotTableField ( XmlNamespaceManager ns, XmlNode topNode, ExcelPivotTable table, int index, int baseIndex ) : System
SetCacheFieldNode ( XmlNode cacheField ) : void
SetDateGroup ( eDateGroupBy GroupBy, DateTime StartDate, DateTime EndDate, int interval ) : ExcelPivotTableFieldDateGroup
SetNumericGroup ( double start, double end, double interval ) : ExcelPivotTableFieldNumericGroup
ValidateGrouping ( ) : void

Method Details

AddDateGrouping() public method

Add a date grouping on this field.

public AddDateGrouping ( eDateGroupBy groupBy ) : void
groupBy	eDateGroupBy	Group by
return	void

AddDateGrouping() public method

Add a date grouping on this field.

public AddDateGrouping ( eDateGroupBy groupBy, System.DateTime startDate, System.DateTime endDate ) : void
groupBy	eDateGroupBy	Group by
startDate	System.DateTime	Fixed start date. Use DateTime.MinValue for auto
endDate	System.DateTime	Fixed end date. Use DateTime.MaxValue for auto
return	void

AddDateGrouping() public method

Add a date grouping on this field.

public AddDateGrouping ( int days, System.DateTime startDate, System.DateTime endDate ) : void
days	int	Number of days when grouping on days
startDate	System.DateTime	Fixed start date. Use DateTime.MinValue for auto
endDate	System.DateTime	Fixed end date. Use DateTime.MaxValue for auto
return	void

AddNumericGrouping() public method

Add numberic grouping to the field

public AddNumericGrouping ( double Start, double End, double Interval ) : void
Start	double	Start value
End	double	End value
Interval	double	Interval
return	void