SpreadJS 14
GC.Spread.Sheets.Slicers Namespace / TableSlicerData class
In This Topic
    TableSlicerData class
    In This Topic

    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.Sheets.Slicers.TableSlicerData

    Constructors
     NameDescription
    public ConstructorRepresents table slicer data.  
    Top
    Methods
     NameDescription
    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 MethodGets the slicer data of the table.  
    public MethodGets the table of the table slicer data.  
    public MethodRefreshes the table slicer data.  
    Top
    See Also