 | WorksheetGetLastDataCellAddress Method |
Gets the last existing cell with data in the current worksheet (bottom right)
Namespace: NanoXLSXAssembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.4+e304ab0274fa680d1e83f83c8f76c3bd5a54caf2
Syntaxpublic Address? GetLastDataCellAddress()
Return Value
NullableAddressNullable Cell Address. If no cell address could be determined, null will be returned
RemarksGetLastDataCellAddress() will ignore formatted (or with definitions of hidden states, AutoFilters, heights or widths) but empty cells after the last cell with data.
If you want the last defined cell, use
GetLastCellAddress instead.
See Also