Click or drag to resize
NanoXLSX

WorksheetGetLastRowNumber Method

Gets the last existing row number in the current worksheet (zero-based)

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.4+e304ab0274fa680d1e83f83c8f76c3bd5a54caf2
Syntax
C#
public int GetLastRowNumber()

Return Value

Int32
Zero-based row number. In case of an empty worksheet, -1 will be returned
Remarks
GetLastRowNumber() will not return the last row with data in any case. If there is a formatted (or with the definition of row height or hidden state) but empty cell (or many) after the last cell with data, GetLastRowNumber() will return the row number of this empty cell. Use GetLastDataRowNumber in this case.
See Also