Click or drag to resize

XlsSlicer Class

Represents a slicer in an Excel worksheet. A slicer is a visual filter that allows users to interactively filter data in a pivot table or table.
Inheritance Hierarchy
System Object
Spire.Xls.Core.Spreadsheet XlsObject
Spire.Xls XlsSlicer

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public class XlsSlicer : XlsObject

The XlsSlicer type exposes the following members.

Properties
Name Description
Public property Caption
Gets or sets the caption of the specified slicer.
Public property ColumnWidth
Gets the width, in points, of each column in the slicer.
Public property Height
Gets or sets the height of the specified slicer, in points.
Public property Name
Gets or sets the name of the specified slicer.
Public property NumberOfColumns
Gets or sets the number of columns in the specified slicer.
Public property Parent
Reference to Parent object. Read-only.
(Inherited from XlsObject .)
Public property PositionLocked
Gets or sets whether the specified slicer can be moved or resized by using the user interface.
Protected property ReferenceCount
Get quantity of instance references.
(Inherited from XlsObject .)
Public property RowHeight
Gets or sets the height, in points, of each row in the specified slicer.
Public property ShowCaption
Gets or sets whether to show the header that displays the slicer caption. The default value is true.
Public property SlicerCache
Gets the SlicerCache object associated with the slicer. Read-only. Lazily initializes the SlicerCache if it's null.
Public property StyleType
Gets or sets the type of slicer style. The default type is SlicerStyleLight1.
Public property Width
Gets or sets the width of the specified slicer, in points.
Top
Methods
Name Description
Protected method AddReference
Increase the quantity of reference. User must use this method when new wrapper on object is created or reference on object stored.
(Inherited from XlsObject .)
Protected method CheckDisposed
Checks whether object was disposed and throws exception if it was.
(Inherited from XlsObject .)
Public method Dispose
Dispose object and free resources.
(Inherited from XlsObject .)
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object .)
Protected method Finalize
Destructor. Call dispose method of current object.
(Inherited from XlsObject .)
Protected method FindParent(Type)
This method is used to find parent with specific type.
(Inherited from XlsObject .)
Protected method FindParent( Type )
Find parent of object.
(Inherited from XlsObject .)
Protected method FindParent(Type, Boolean)
This method is used to find parent with specific type.
(Inherited from XlsObject .)
Protected method FindParents
Finds parent objects.
(Inherited from XlsObject .)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object .)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object .)
Protected method MemberwiseClone
Creates a shallow copy of the current Object .
(Inherited from Object .)
Protected method OnDispose
Method which can be overriden by users to take any specific actions when object is disposed.
(Inherited from XlsObject .)
Public method Refresh
Refreshes the slicer. Meanwhile, refreshes the related Table or PivotTables.
Protected method ReleaseReference
Decrease quantity of Reference. User must call this method when freeing resources.
(Inherited from XlsObject .)
Protected method SetParent
Sets parent of the object.
(Inherited from XlsObject .)
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Top
Fields
Name Description
Protected field m_bIsDisposed
Flag which indicates if the object was disposed or not.
(Inherited from XlsObject .)
Top
See Also