Apply Slicer Style

Spread.Services Documentation
Apply Slicer Style
Collapse All Expand All

Spread.Services Documentation > Developer's Guide > Manage Data in Spread Component > Use Slicer > Apply Slicer Style

When you create a slicer, it is mandatory to create a slicer cache first and then use the slicer cache created base on the column of the table or the pivot table.

The SlicerCaches collection in Spread.Services holds all the slicer caches in the workbook.

### Set slicer to built-in style

You can set your slicer to built-in style by using the Style property of the ISlicer interface.

Refer to the following example code to set slicer to built-in style.

C# | Copy Code
--- | ---

    //create slicer cache for table.
    ISlicerCache cache = workbook.SlicerCaches.Add(table, "Category", "categoryCache");

    //add slicer
    ISlicer slicer1 = cache.Slicers.Add(workbook.Worksheets["Sheet1"], "cate1", "Category", 200, 200, 100, 200);

    //set slicer style to build in style.
    slicer1.Style = workbook.TableStyles["SlicerStyleLight1"];

###

Copyright © GrapeCity, inc. All rights reserved.