Click or drag to resize
NanoXLSX

WorksheetGetLastCellAddress Method

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

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.3+98f265239ae8df4639650ecd7029244cc5e52dfc
Syntax
C#
public Address? GetLastCellAddress()

Return Value

NullableAddress
Nullable Cell Address. If no cell address could be determined, null will be returned
Remarks
GetLastCellAddress() will not return the last cell with data in any case. If there is a formatted (or with definitions of hidden states, AutoFilters, heights or widths) but empty cell (or many) after the last cell with data, GetLastCellAddress() will return the address of this empty cell. Use GetLastDataCellAddress in this case.
See Also