Click or drag to resize
NanoXLSX

WorksheetGetLastDataColumnNumber Method

Gets the last existing column number with data in the current worksheet (zero-based)

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.4+e304ab0274fa680d1e83f83c8f76c3bd5a54caf2
Syntax
C#
public int GetLastDataColumnNumber()

Return Value

Int32
Zero-based column number. in case of an empty worksheet, -1 will be returned
Remarks
GetLastDataColumnNumber() will ignore formatted (or with the definition of AutoFilter, column width or hidden state) but empty cells after the last column with data. If you want the last defined column, use GetLastColumnNumber instead.
See Also