Spread.Sheets Documentation
clear Method
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.
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