getColumnWidthInPixels - cfsimplicity/spreadsheet-cfml GitHub Wiki

Gets the width of a column in the currently active sheet in pixels.

getColumnWidthInPixels( workbook, column )

Required arguments

  • workbook spreadsheet object
  • column numeric

Chainable? Yes but ends the chain.

Example

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