Class ExcelPivotTableFieldItemsCollection¶

Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll

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

Inheritance¶

object ← ExcelPivotTableFieldCollectionBase<ExcelPivotTableFieldItem> ← ExcelPivotTableFieldItemsCollection

Implements¶

IEnumerable
IEnumerable<ExcelPivotTableFieldItem>

Inherited Members¶

ExcelPivotTableFieldCollectionBase<ExcelPivotTableFieldItem>.Count
ExcelPivotTableFieldCollectionBase<ExcelPivotTableFieldItem>.GetEnumerator()
ExcelPivotTableFieldCollectionBase<ExcelPivotTableFieldItem>.this[int]
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

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, null 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