SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / clear Method
The start row index.
The start column index.
The number of rows to clear.
The number of columns to clear.
The area to clear.
The clear type.
In This Topic
    clear Method
    In This Topic
    Clears the specified area.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var value; // Type: any
    value = instance.clear(row, column, rowCount, columnCount, area, storageType);
    function clear( 
       row : number,
       column : number,
       rowCount : number,
       columnCount : number,
       area : SheetArea,
       storageType : StorageType
    ) : any;

    Parameters

    row
    The start row index.
    column
    The start column index.
    rowCount
    The number of rows to clear.
    columnCount
    The number of columns to clear.
    area
    The area to clear.
    storageType
    The clear type.
    Example
    This example clears the data from the specified range.
    activeSheet.getCell(0,0).value("A1");
    activeSheet.clear(0,0,3,3,GC.Spread.Sheets.SheetArea.viewport,GC.Spread.Sheets.StorageType.data);
    See Also

    Reference

    Worksheet type