spreadsheetGetLastRowNumber

Returns the number of the last row in the active sheet.

spreadsheetGetLastRowNumber(spreadsheetObj) → returns numeric

This function requires Adobe ColdFusion 2025 and up.  Not supported on Lucee, etc.
  1. CFDocs
  2. Functions
  3. ColdFusion 2025 New Functions and Tags
  4. spreadsheetGetLastRowNumber
  5. CF2025+
  6. 0 Issue
  7. Edit
See Also:   spreadsheetgetcolumncount

Argument Reference

spreadsheetObj any
Required

The spreadsheet object.

Examples
Sample code invoking the spreadsheetGetLastRowNumber function

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub