 | WorksheetGetLastRowNumber Method |
Gets the last existing row number in the current worksheet (zero-based)
Namespace: NanoXLSXAssembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.7+3223c8b99fcd3402b4ae016daa480abac16f8a9f
Syntaxpublic int GetLastRowNumber()
Return Value
Int32Zero-based row number. In case of an empty worksheet, -1 will be returned
RemarksGetLastRowNumber() 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