SpreadsheetGetLastRowNumber

Retrieves the row number of the last row with data in a spreadsheet.

Method Signature

SpreadsheetGetLastRowNumber(spreadsheetObj=[any])

Arguments

Argument	Type	Required	Description	Default
spreadsheetObj	ANY	true	The spreadsheet object.

Examples

Get the last row with data:

// Find last row
var spreadsheet = SpreadsheetNew();
SpreadsheetAddRows( spreadsheet, [ ["Row1"], ["Row2"], ["Row3"] ] );
var lastRow = SpreadsheetGetLastRowNumber( spreadsheet );
println( "Last row: " & lastRow );  // Output: 3

Append data to end:

// Add to end of spreadsheet
var spreadsheet = SpreadsheetRead( "/path/to/file.xlsx" );
var lastRow = SpreadsheetGetLastRowNumber( spreadsheet );
SpreadsheetSetCellValue( spreadsheet, lastRow + 1, 1, "New data" );

Related

• SpreadsheetGetColumnCount() - Get column count

• SpreadsheetInfo() - Get spreadsheet info

• SpreadsheetAddRow() - Add a row