 | WorksheetGetLastDataRowNumber Method |
Gets the last existing row number with data in the current worksheet (zero-based)
Namespace: NanoXLSXAssembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.4+e304ab0274fa680d1e83f83c8f76c3bd5a54caf2
Syntaxpublic int GetLastDataRowNumber()
Return Value
Int32Zero-based row number. in case of an empty worksheet, -1 will be returned
RemarksGetLastDataColumnNumber() will ignore formatted (or with the definition of row height or hidden state) but empty cells after the last column with data.
If you want the last defined column, use
GetLastRowNumber instead.
See Also