SpreadJS 13
GC.Spread.Sheets.Tables Namespace / Table type / insertColumns Method
Column index at which to add the new columns, based on table index.
The number of columns to add.
Whether insert columns before the specified column index or after. By default, insert before.
In This Topic
    insertColumns Method
    In This Topic
    Insert count number columns in this table before the specified table col index.
    Syntax
    var instance = new GC.Spread.Sheets.Tables.Table(name,
                                                    row,
                                                    col,
                                                    rowCount,
                                                    colCount,
                                                    style,
                                                    options,
                                                    options.showHeader,
                                                    options.showFooter,
                                                    options.useFooterDropDownList,
                                                    options.showResizeHandle);
    instance.insertColumns(col, count, isInsertAfter);
    function insertColumns( 
       col : number,
       count : number,
       isInsertAfter : boolean
    ) : void;

    Parameters

    col
    Column index at which to add the new columns, based on table index.
    count
    The number of columns to add.
    isInsertAfter
    Whether insert columns before the specified column index or after. By default, insert before.
    Example
    var table = activeSheet.tables.add("table1", 1, 1, 10, 5, GC.Spread.Sheets.Tables.TableTheme.medium2);
    table.insertColumns(3, 1);
    See Also

    Reference

    Table type