Skip to content
Julian Halliwell edited this page Mar 8, 2017 · 9 revisions

Formats/styles the contents of multiple rows.

formatRows( workbook, format, range )

##Required arguments

  • workbook spreadsheet object
  • format struct: See Formatting options for details.
  • range string: a comma-delimited list of ranges.Each value can be either a single number or a range of numbers with a hyphen, e.g. "1,2-5"

##Example

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

Clone this wiki locally