Class ExcelPivotTableField

Namespace

OfficeOpenXml.Table.PivotTable

Assembly

Magicodes.EPPlus.dll

public class ExcelPivotTableField : XmlHelper

Inheritance

object

XmlHelper

ExcelPivotTableField

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

ExtensionMethods.IsNumeric(object)

Properties

Axis

public ePivotFieldAxis Axis { get; }

Property Value

ePivotFieldAxis

Compact

public bool Compact { get; set; }

Property Value

bool

Grouping

public ExcelPivotTableFieldGroup Grouping { get; }

Property Value

ExcelPivotTableFieldGroup

IncludeNewItemsInFilter

public bool IncludeNewItemsInFilter { get; set; }

Property Value

bool

Index

public int Index { get; set; }

Property Value

int

IsColumnField

public bool IsColumnField { get; }

Property Value

bool

IsDataField

public bool IsDataField { get; }

Property Value

bool

IsPageField

public bool IsPageField { get; }

Property Value

bool

IsRowField

public bool IsRowField { get; }

Property Value

bool

Items

public ExcelPivotTableFieldCollectionBase<ExcelPivotTableFieldItem> Items { get; }

Property Value

ExcelPivotTableFieldCollectionBase<ExcelPivotTableFieldItem>

MultipleItemSelectionAllowed

public bool MultipleItemSelectionAllowed { get; set; }

Property Value

bool

Name

public string Name { get; set; }

Property Value

string

Outline

public bool Outline { get; set; }

Property Value

bool

PageFieldSettings

public ExcelPivotTablePageFieldSettings PageFieldSettings { get; }

Property Value

ExcelPivotTablePageFieldSettings

ShowAll

public bool ShowAll { get; set; }

Property Value

bool

ShowAsCaption

public bool ShowAsCaption { get; set; }

Property Value

bool

ShowDropDowns

public bool ShowDropDowns { get; set; }

Property Value

bool

ShowInFieldList

public bool ShowInFieldList { get; set; }

Property Value

bool

ShowMemberPropertyInCell

public bool ShowMemberPropertyInCell { get; set; }

Property Value

bool

ShowMemberPropertyToolTip

public bool ShowMemberPropertyToolTip { get; set; }

Property Value

bool

Sort

public eSortType Sort { get; set; }

Property Value

eSortType

SubTotalFunctions

public eSubTotalFunctions SubTotalFunctions { get; set; }

Property Value

eSubTotalFunctions

SubtotalTop

public bool SubtotalTop { get; set; }

Property Value

bool

Methods

AddDateGrouping(eDateGroupBy)

public void AddDateGrouping(eDateGroupBy groupBy)

Parameters

groupBy eDateGroupBy

AddDateGrouping(eDateGroupBy, DateTime, DateTime)

public void AddDateGrouping(eDateGroupBy groupBy, DateTime startDate, DateTime endDate)

Parameters

groupBy eDateGroupBy

startDate DateTime

endDate DateTime

AddDateGrouping(int, DateTime, DateTime)

public void AddDateGrouping(int days, DateTime startDate, DateTime endDate)

Parameters

days int

startDate DateTime

endDate DateTime

AddNumericGrouping(double, double, double)

public void AddNumericGrouping(double Start, double End, double Interval)

Parameters

Start double

End double

Interval double