Class ExcelPivotTableFieldItemsCollection

Inheritance
System.Object
ExcelPivotTableFieldCollectionBase<ExcelPivotTableFieldItem>
ExcelPivotTableFieldItemsCollection
Implements
System.Collections.Generic.IEnumerable<ExcelPivotTableFieldItem>
System.Collections.IEnumerable
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll
Syntax
public class ExcelPivotTableFieldItemsCollection : ExcelPivotTableFieldCollectionBase<ExcelPivotTableFieldItem>, IEnumerable<ExcelPivotTableFieldItem>, IEnumerable

Methods

Contains(Object)

It the object exists in the cache

Declaration
public bool Contains(object value)
Parameters
Type Name Description
System.Object value

The object to check for existance
Returns
Type Description
System.Boolean

GetByValue(Object)

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

Declaration
public ExcelPivotTableFieldItem GetByValue(object value)
Parameters
Type Name Description
System.Object value

The value
Returns
Type Description
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.

Declaration
public int GetIndexByValue(object value)
Parameters
Type Name Description
System.Object value

The value
Returns
Type Description
System.Int32

The index of the item

Refresh()

Refreshes the data of the cache field

Declaration
public void Refresh()

SelectSingleItem(Int32)

Hide all items except the item at the supplied index

Declaration
public void SelectSingleItem(int index)
Parameters
Type Name Description
System.Int32 index

ShowAll()

Set Hidden to false for all items in the collection

Declaration
public void ShowAll()

ShowDetails(Boolean)

Set the ShowDetails for all items.

Declaration
public void ShowDetails(bool isExpanded = true)
Parameters
Type Name Description
System.Boolean isExpanded

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

Implements

System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable