Class ExcelPivotTableFieldItemsCollection

Namespace

OfficeOpenXml.Table.PivotTable

Assembly

EPPlus.dll

public class ExcelPivotTableFieldItemsCollection : ExcelPivotTableFieldCollectionBase<ExcelPivotTableFieldItem>, IEnumerable<ExcelPivotTableFieldItem>, IEnumerable

Inheritance

object

ExcelPivotTableFieldCollectionBase<ExcelPivotTableFieldItem>

ExcelPivotTableFieldItemsCollection

Implements

IEnumerable<ExcelPivotTableFieldItem>

IEnumerable

Inherited Members

ExcelPivotTableFieldCollectionBase<ExcelPivotTableFieldItem>.GetEnumerator()

ExcelPivotTableFieldCollectionBase<ExcelPivotTableFieldItem>.Count

ExcelPivotTableFieldCollectionBase<ExcelPivotTableFieldItem>.this[int]

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Methods

Contains(object)

It the object exists in the cache

public bool Contains(object value)

Parameters

value object

The object to check for existance

Returns

bool

GetByValue(object)

Get the item with the value supplied. If the value does not exist, null is returned.

public ExcelPivotTableFieldItem GetByValue(object value)

Parameters

value object

The value

Returns

ExcelPivotTableFieldItem

The pivot table field

GetIndexByValue(object)

Get the index of the item with the value supplied. If the value does not exist, -1 is returned.

public int GetIndexByValue(object value)

Parameters

value object

The value

Returns

int

The index of the item

Refresh()

Refreshes the data of the cache field

public void Refresh()

SelectSingleItem(int)

Hide all items except the item at the supplied index

public void SelectSingleItem(int index)

Parameters

index int

ShowAll()

Set Hidden to false for all items in the collection

public void ShowAll()

ShowDetails(bool)

Set the ShowDetails for all items.

public void ShowDetails(bool isExpanded = true)

Parameters

isExpanded bool

The value of true is set all items to be expanded. The value of false set all items to be collapsed