clearCellRange

Clears the specified cell range of all styles and values.

clearCellRange( workbook, startRow, startColumn, endRow, endColumn )

Required arguments

• workbook spreadsheet object
• startRow numeric
• startColumn numeric
• endRow numeric
• endColumn numeric

Chainable? Yes.

Example

data = QueryNew( "First,Last","VarChar,VarChar",[ [ "Susi","Sorglos" ],[ "Frumpo","McNugget" ] ] );
spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
spreadsheet.clearCellRange( workbook,1,2,1,1 );