Class ExcelPivotTableSlicerItemCollection
A collection of items in a pivot table slicer.
Inherited Members
Namespace: OfficeOpenXml.Drawing.Slicer
Assembly: EPPlus.dll
Syntax
public class ExcelPivotTableSlicerItemCollection : IEnumerable<ExcelPivotTableSlicerItem>, IEnumerableProperties
Count
Number of items in the collection.
Declaration
public int Count { get; }Property Value
| Type | Description |
|---|---|
| int |
this[int]
Get the value at the specific position in the collection
Declaration
public ExcelPivotTableSlicerItem this[int index] { get; }Parameters
| Type | Name | Description |
|---|---|---|
| int | index | The position |
Property Value
| Type | Description |
|---|---|
| ExcelPivotTableSlicerItem |
Methods
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 supplied value.
Declaration
public ExcelPivotTableSlicerItem GetByValue(object value)Parameters
| Type | Name | Description |
|---|---|---|
| object | value | The value |
Returns
| Type | Description |
|---|---|
| ExcelPivotTableSlicerItem | The item matching the supplied value. Returns null if no value matches. |
GetEnumerator()
Get the enumerator for the collection
Declaration
public IEnumerator<ExcelPivotTableSlicerItem> GetEnumerator()Returns
| Type | Description |
|---|---|
| IEnumerator<ExcelPivotTableSlicerItem> |
GetIndexByValue(object)
Get the index of the item with supplied value.
Declaration
public int GetIndexByValue(object value)Parameters
| Type | Name | Description |
|---|---|---|
| object | value | The value |
Returns
| Type | Description |
|---|---|
| int | The item matching the supplied value. Returns -1 if no value matches. |
Refresh()
Refresh the items from the shared items or the group items.
Declaration
public void Refresh()