setRowHeight - cfsimplicity/spreadsheet-cfml GitHub Wiki

Set the height of a row in points.

setRowHeight( workbook, row, height )

Required arguments

  • workbook spreadsheet object
  • row numeric
  • height numeric: in points.

Chainable? Yes.

Example

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