getColumnCount - cfsimplicity/spreadsheet-cfml GitHub Wiki

Returns the maximum number of columns in the currently active or specified sheet.

getColumnCount( workbook [, sheetNameOrNumber ] )

Required arguments

  • workbook spreadsheet object

Optional arguments

  • sheetNameOrNumber string OR numeric: the name or number of the sheet within the workbook to operate on. If you omit this argument, the currently active sheet will be used.

Chainable? Yes but ends the chain.

Example

spreadsheet=New spreadsheet();
workbook=spreadsheet.new();
spreadsheet.addRow( workbook,"1a,1b" );
spreadsheet.addRow( workbook,"2a,2b,2c" );
spreadsheet.addRow( workbook,"3a" );
maxColumns=spreadsheet.getColumnCount( workbook );//returns 3;