Skip to content
Julian Halliwell edited this page Feb 25, 2015 · 4 revisions

Clears the specified cell of all styles and values.

clearCell( workbook, row, column )

##Required arguments

  • workbook spreadsheet object
  • row numeric
  • column numeric

##Example

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

Clone this wiki locally