Class ExcelPivotTableSlicerItemCollection
A collection of items in a pivot table slicer.
Inheritance
System.Object
ExcelPivotTableSlicerItemCollection
Implements
System.Collections.Generic.IEnumerable<ExcelPivotTableSlicerItem>
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.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 |
|---|---|
| System.Int32 |
Item[Int32]
Get the value at the specific position in the collection
Declaration
public ExcelPivotTableSlicerItem this[int index] { get; }Parameters
| Type | Name | Description |
|---|---|---|
| System.Int32 | 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 |
|---|---|---|
| System.Object | value | The object to check for existance |
Returns
| Type | Description |
|---|---|
| System.Boolean |
GetByValue(Object)
Get the item with supplied value.
Declaration
public ExcelPivotTableSlicerItem GetByValue(object value)Parameters
| Type | Name | Description |
|---|---|---|
| System.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 |
|---|---|
| System.Collections.Generic.IEnumerator<ExcelPivotTableSlicerItem> |
GetIndexByValue(Object)
Get the index of the item with supplied value.
Declaration
public int GetIndexByValue(object value)Parameters
| Type | Name | Description |
|---|---|---|
| System.Object | value | The value |
Returns
| Type | Description |
|---|---|
| System.Int32 | 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()Explicit Interface Implementations
IEnumerable.GetEnumerator()
Get the enumerator for the collection
Declaration
IEnumerator IEnumerable.GetEnumerator()Returns
| Type | Description |
|---|---|
| System.Collections.IEnumerator |
Implements
System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable