Click or drag to resize
NanoXLSX

WorksheetGetLastDataCellAddress Method

Gets the last existing cell with data in the current worksheet (bottom right)

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.4+e304ab0274fa680d1e83f83c8f76c3bd5a54caf2
Syntax
C#
public Address? GetLastDataCellAddress()

Return Value

NullableAddress
Nullable Cell Address. If no cell address could be determined, null will be returned
Remarks
GetLastDataCellAddress() 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