getLastRowNumber - cfsimplicity/spreadsheet-cfml GitHub Wiki

Returns the number of the last row in the currently active or specified sheet, including any blank rows.

getLastRowNumber( 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, "A1" );
spreadsheet.addRow( workbook, "B1" );
spreadsheet.addRow( workbook, "C1" );
numberOfRows = spreadsheet.getLastRowNumber( workbook );//returns 3;