SpreadJS 13
GC.Spread.Sheets.Tables Namespace / Table type
In This Topic
    Table type
    In This Topic
    Represents a table that can be added in a sheet.
    Syntax
    var instance = new GC.Spread.Sheets.Tables.Table(name,
                                                    row,
                                                    col,
                                                    rowCount,
                                                    colCount,
                                                    style,
                                                    options,
                                                    options.showHeader,
                                                    options.showFooter,
                                                    options.useFooterDropDownList,
                                                    options.showResizeHandle);
    function Table;
    Inheritance Hierarchy

    Object
       GC.Spread.Sheets.Tables.Table

    Constructors
     NameDescription
    public ConstructorRepresents a table that can be added in a sheet.  
    Top
    Methods
     NameDescription
    public MethodGets or sets the allowAutoExpandState of the table.  
    public MethodGets or sets whether to generate columns automatically while binding to a data source.  
    public MethodGets or sets a value that indicates whether to display an alternating column style.  
    public MethodGets or sets a value that indicates whether to display an alternating row style.  
    public MethodGets or sets the dataSource and binding columns and path for the table.  
    public MethodBinds the columns using the specified data fields.  
    public MethodGets or sets the binding path for cell-level binding in the table.  
    public MethodClears the dirty status from the current table.  
    public MethodGets the cell range for the table data area.  
    public MethodDelete count number columns in the table at the specified table col index.  
    public MethodDeletes the rows in this table at the specified table row index.  
    public MethodGets or sets whether the table column's filter button is displayed.  
    public MethodGets the footer index in the sheet.  
    public MethodGets the table footer formula with the specified index.  
    public MethodGets the table header text with the specified table index.  
    public MethodGets the table footer value with the specified index.  
    public MethodGet array of dirty rows.  
    public MethodGets the header index in the sheet.  
    public MethodGets or sets a value that indicates whether to highlight the first column.  
    public MethodGets or sets a value that indicates whether to highlight the last column.  
    public MethodInsert count number columns in this table before the specified table col index.  
    public MethodInsert rows in this table before the specified table row index.  
    public MethodGets or sets the table name.  
    public MethodGets the range for the entire table.  
    public MethodGets the row filter for the table.  
    public MethodSets a formula to the table's data range with the specified index.  
    public MethodSets the table footer formula with the specified index.  
    public MethodSets the table header text with the specified table index.  
    public MethodSets the table footer value with the specified index.  
    public MethodGets or sets a value that indicates whether to display a footer.  
    public MethodGets or sets a value that indicates whether to display a header.  
    public MethodGets or sets a value that indicates whether to display the resize handle for table.  
    public MethodGets or sets a style for the table.  
    public MethodGets or sets a value that indicates whether to use the footer dropdown list for a total row.  
    Top
    See Also