clear Method

Clears the specified area.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: any
value = instance.clear(row, column, rowCount, columnCount, area, type);

function clear( 
   row : number,
   column : number,
   rowCount : number,
   columnCount : number,
   area : SheetArea,
   type : 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.
type: The clear type.

Example

This example clears the data from the specified range.

Javascript

activeSheet.getCell(0,0).value("A1");
activeSheet.clear(0,0,3,3,GcSpread.Sheets.SheetArea.viewport,GcSpread.Sheets.StorageType.Data);

Reference

Sheet type