SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / addColumns Method
Column index at which to add the new columns.
The number of columns to add.
In This Topic
    addColumns Method
    In This Topic
    Adds the column or columns to the data model at the specified index.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var value; // Type: any
    value = instance.addColumns(col, count);
    function addColumns( 
       col : number,
       count : number
    ) : any;

    Parameters

    col
    Column index at which to add the new columns.
    count
    The number of columns to add.
    Example
    This example adds columns.
    sheet.setValue(0, 0, "value");
    sheet.addRows(0, 2);
    sheet.addColumns(0, 2);
    sheet.setRowHeight(0, 50.0,GC.Spread.Sheets.SheetArea.viewport);
    sheet.setColumnWidth(0, 150.0,GC.Spread.Sheets.SheetArea.viewport);
    sheet.getRange(0, -1, 1, -1,GC.Spread.Sheets.SheetArea.viewport).backColor("Gray");
    sheet.getRange(-1, 0, -1, 1,GC.Spread.Sheets.SheetArea.viewport).backColor ("Brown");
    See Also

    Reference

    Worksheet type