-
-
Notifications
You must be signed in to change notification settings - Fork 36
clearCellRange
Julian Halliwell edited this page Feb 25, 2015
·
5 revisions
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
##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 );