Class ExcelPivotTableFieldItemsCollection
Inheritance
ExcelPivotTableFieldItemsCollection
Inherited Members
Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll
Syntax
public class ExcelPivotTableFieldItemsCollection : ExcelPivotTableFieldCollectionBase<ExcelPivotTableFieldItem>, IEnumerable<ExcelPivotTableFieldItem>, IEnumerableMethods
Contains(object)
It the object exists in the cache
Declaration
public bool Contains(object value)Parameters
| Type | Name | Description |
|---|---|---|
| object | value | The object to check for existance |
Returns
| Type | Description |
|---|---|
| bool |
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 |
|---|---|---|
| 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, -1 is returned.
Declaration
public int GetIndexByValue(object value)Parameters
| Type | Name | Description |
|---|---|---|
| object | value | The value |
Returns
| Type | Description |
|---|---|
| int | The index of the item |
Refresh()
Refreshes the data of the cache field
Declaration
public void Refresh()SelectSingleItem(int)
Hide all items except the item at the supplied index
Declaration
public void SelectSingleItem(int index)Parameters
| Type | Name | Description |
|---|---|---|
| int | index |
ShowAll()
Set Hidden to false for all items in the collection
Declaration
public void ShowAll()ShowDetails(bool)
Set the ShowDetails for all items.
Declaration
public void ShowDetails(bool isExpanded = true)Parameters
| Type | Name | Description |
|---|---|---|
| bool | isExpanded | The value of true is set all items to be expanded. The value of false set all items to be collapsed |