[]
        
(Showing Draft Content)

Modify Table Layout for Slicer Style

You can modify the table layout for the slicer style applied in your spreadsheet by modifying some settings including the ISlicer.RowHeight and ISlicer.DisplayHeader of the ISlicer .

Refer to the following example code to modify table layout for slicer style.

//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);

slicer1.NumberOfColumns = 2;
//slicer1.ColumnWidth = 10;
slicer1.RowHeight = 50;
slicer1.DisplayHeader = false;