# 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:

```js
// 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:

```js
// 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()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetgetcolumncount) - Get column count
* [SpreadsheetInfo()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetinfo) - Get spreadsheet info
* [SpreadsheetAddRow()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetaddrow) - Add a row