SpreadJS Documentation
TableSlicerData class
GC.Spread.Sheets.Slicers Namespace : TableSlicerData class

Syntax
var instance = new GC.Spread.Sheets.Slicers.TableSlicerData(table);
function TableSlicerData;
Example
//This example creates a slicer for the table.
//create table
var dataSource = [
    { Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
    { Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
    { Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicerData = new GC.Spread.Sheets.Slicers.TableSlicerData(table)
//Set slicer data to item slicer.
var slicer = new GC.Spread.Sheets.Slicers.ItemSlicer("slicer", slicerData, "Name");
//Add the item slicer to the dom tree.
//The "slicerHost" is the div you want to add the slicer's dom to.
$("#slicerHost").append(slicer.getDOMElement());
Inheritance Hierarchy

Object
   GC.Spread.Slicers.GeneralSlicerData
      GC.Spread.Sheets.Slicers.TableSlicerData

Constructors
 NameDescription
public ConstructorRepresents table slicer data.  
Top
Fields
 NameDescription
public Field (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Field (Inherited from GC.Spread.Slicers.GeneralSlicerData)
Top
Methods
 NameDescription
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public MethodFilters the data that corresponds to the specified column name and exclusive data indexes.  
public MethodUnfilters the data that corresponds to the specified column name.  
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public MethodGets the slicer data of the table.  
public MethodGets the table of the table slicer data.  
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public MethodRefreshes the table slicer data.  
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
public Method (Inherited from GC.Spread.Slicers.GeneralSlicerData)
Top
See Also

Reference

GC.Spread.Sheets.Slicers Namespace