Class SlicerCollection

Represents the slicer collection class used by the spreadsheet model.

Inheritance

object

SlicerCollection

Implements

IEnumerable<Slicer>

IEnumerable

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: DRIT.Spreadsheet.Slicers

Assembly: DRIT.Spreadsheet.dll

Syntax

public class SlicerCollection : IEnumerable<Slicer>, IEnumerable

Properties

Count

Gets the number of slicers in the collection.

Declaration

public int Count { get; }

Property Value

Type	Description
int

this[int]

Gets the slicer at the specified index.

Declaration

public Slicer this[int index] { get; }

Parameters

Type	Name	Description
int	index

Property Value

Type	Description
Slicer

this[string]

Gets the slicer with the specified name.

Declaration

public Slicer this[string name] { get; }

Parameters

Type	Name	Description
string	name

Property Value

Type	Description
Slicer

Methods

Add(PivotTable, string, PivotField)

Adds a slicer connected to a pivot table field and returns its index.

Declaration

public int Add(PivotTable pivotTable, string cellRef, PivotField field)

Parameters

Type	Name	Description
PivotTable	pivotTable	The pivot table to connect to.
string	cellRef	The cell reference for the top-left corner of the slicer (e.g. "B22").
PivotField	field	The pivot field to filter on.

Returns

Type	Description
int

Add(PivotTable, string, string)

Adds a slicer connected to a pivot table field by name and returns its index.

Declaration

public int Add(PivotTable pivotTable, string cellRef, string fieldName)

Parameters

Type	Name	Description
PivotTable	pivotTable	The pivot table to connect to.
string	cellRef	The cell reference for the top-left corner of the slicer (e.g. "B22").
string	fieldName	The name of the pivot field to filter on.

Returns

Type	Description
int

GetEnumerator()

Retrieves the requested enumerator from SlicerCollection.

Declaration

public IEnumerator<Slicer> GetEnumerator()

Returns

Type	Description
IEnumerator<Slicer>	The get enumerator returned by the operation.

Remove(Slicer)

Removes a slicer from the collection.

Declaration

public void Remove(Slicer slicer)

Parameters

Type	Name	Description
Slicer	slicer

Implements

IEnumerable<T>

IEnumerable