setColumnWidth - cfsimplicity/spreadsheet-cfml GitHub Wiki

Sets the width of a column.

setColumnWidth( workbook, column, width )

Required arguments

  • workbook spreadsheet object
  • column numeric
  • width numeric: desired number of characters wide (normally based on the character 0 in the default font).

Chainable? Yes.

Example

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