C# 클래스 OfficeOpenXml.Table.PivotTable.ExcelPivotTableField

A pivot table field.

상속: XmlHelper

파일 보기 프로젝트 열기: pruiz/EPPlus 1 사용 예제들

Private Properties

프로퍼티	타입	설명
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

공개 메소드들

메소드	설명
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

비공개 메소드들

메소드	설명
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

메소드 상세

AddDateGrouping() 공개 메소드

Add a date grouping on this field.

public AddDateGrouping ( eDateGroupBy groupBy ) : void
groupBy	eDateGroupBy	Group by
리턴	void

AddDateGrouping() 공개 메소드

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
리턴	void

AddDateGrouping() 공개 메소드

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
리턴	void

AddNumericGrouping() 공개 메소드

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
리턴	void