SpreadJS 13
GC.Spread.Sheets.CellTypes Namespace / RangeTemplate type / RangeTemplate Constructor
the referenced worksheet, the sheet could be an individual sheet outside the workbook.
the template scope start row.
the template scope start col.
the template scope row count.
the template scope col count.
In This Topic
    RangeTemplate Constructor
    In This Topic
    Syntax
    var instance = new GC.Spread.Sheets.CellTypes.RangeTemplate(sheet, row, col, rowCount, colCount);
    function RangeTemplate( 
       sheet : Worksheet,
       (optional) row : number,
       (optional) col : number,
       (optional) rowCount : number,
       (optional) colCount : number
    ) : RangeTemplate;

    Parameters

    sheet
    the referenced worksheet, the sheet could be an individual sheet outside the workbook.
    row
    the template scope start row.
    col
    the template scope start col.
    rowCount
    the template scope row count.
    colCount
    the template scope col count.
    Example
    var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"), { sheetCount: 2 });
    var sheet = spread.getActiveSheet();
    var sheet2 = spread.getSheetFromName("Sheet2");
    var celltype = new GC.Spread.Sheets.CellTypes.RangeTemplate(sheet2, 0, 0, 6, 4);
    sheet.getRange(0,0,2,2).cellType(celltype);
    See Also