clear Method

Clears the specified area.

Syntax

Javascript (Usage)
Javascript (Specification)

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.

Javascript

activeSheet.getCell(0,0).value("A1");
activeSheet.clear(0,0,3,3,GC.Spread.Sheets.SheetArea.viewport,GC.Spread.Sheets.StorageType.data);

Reference

Worksheet type