 | WorksheetGetLastDataCellAddress Method |
Gets the last existing cell with data in the current worksheet (bottom right)
Namespace: NanoXLSXAssembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.7+3223c8b99fcd3402b4ae016daa480abac16f8a9f
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