SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / getCellType Method
The row index.
The column index.
The sheet area. If this parameter is not provided, it defaults to viewport.
In This Topic
    getCellType Method
    In This Topic
    Gets the cell type.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var value; // Type: Base
    value = instance.getCellType(row, col, sheetArea);
    function getCellType( 
       row : number,
       col : number,
       (optional) sheetArea : SheetArea
    ) : Base;

    Parameters

    row
    The row index.
    col
    The column index.
    sheetArea
    The sheet area. If this parameter is not provided, it defaults to viewport.

    Return Value

    Returns the cell type for the specified cell.
    Example
    This example gets the cell type.
    var cellType = new GC.Spread.Sheets.CellTypes.Button();
    cellType.buttonBackColor("#FFFF00");
    cellType.text("this is a button");
    activeSheet.getCell(0, 2).cellType(cellType);
    
    var cellType = activeSheet.getCellType(0,2,GC.Spread.Sheets.SheetArea.viewport)
    if (cellType instanceof GC.Spread.Sheets.CellTypes.Button) {
          alert("This is a ButtonCellType");
    }
    See Also

    Reference

    Worksheet type