Click or drag to resize
NanoXLSX

WorksheetGetLastColumnNumber Method

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

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.3+98f265239ae8df4639650ecd7029244cc5e52dfc
Syntax
C#
public int GetLastColumnNumber()

Return Value

Int32
Zero-based column number. In case of an empty worksheet, -1 will be returned
Remarks
GetLastColumnNumber() will not return the last column with data in any case. If there is a formatted (or with the definition of AutoFilter, column width or hidden state) but empty cell (or many) after the last cell with data, GetLastColumnNumber() will return the column number of this empty cell. Use GetLastDataColumnNumber in this case.
See Also