formatCell

Jump to bottom Edit New page

Julian Halliwell edited this page Apr 8, 2017 · 12 revisions

Formats/styles the contents of a cell.

formatCell( workbook, format, row, column[, cellStyle] )

Required arguments

workbook spreadsheet object
format struct: See Formatting options for details.
row numeric
column numeric

Optional arguments

cellStyle: Existing cellStyle to re-use.

Example

data = QueryNew( "First,Last","VarChar,VarChar",[ [ "Susi","Sorglos" ],[ "Frumpo","McNugget" ] ] );
spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
spreadsheet.formatCell( workbook,{bold="true"},1,1 );