formatColumns

Formats/styles the contents of multiple columns.

formatColumns( workbook, format, range[, overwriteCurrentStyle [, cellStyle  ] ] )

Required arguments

• workbook spreadsheet object
• format struct: See Formatting options for details. Optional if cellStyle supplied.
• 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"

Optional arguments

• overwriteCurrentStyle boolean default=true: for performance/efficiency reasons all of the existing styles will be completely overwritten when using this method. To preserve existing formatting properties other than the ones being changed, set this flag to false, but please note that this should only be used when formatting a limited number of cells (you may run into errors if applied to too many cells).
• cellStyle POI CellStyle object: an existing cellStyle object containing the desired formatting options. See createCellStyle().

Chainable? Yes.

Example

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