WorksheetSetVerticalSplit(Int32, Boolean, Address, NullableWorksheetWorksheetPane) Method

Sets the vertical split of the worksheet into two panes. The measurement in columns can be used to split and freeze panes

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.7+3223c8b99fcd3402b4ae016daa480abac16f8a9f

Syntax

public void SetVerticalSplit(
	int numberOfColumnsFromLeft,
	bool freeze,
	Address topLeftCell,
	WorksheetWorksheetPane? activePane
)

numberOfColumnsFromLeft Int32: Number of columns from left of the worksheet to the split line. The particular column widths are considered
freeze Boolean: If true, all panes are frozen, otherwise remains movable
topLeftCell Address: Top Left cell address of the bottom right pane (if applicable). Only the column component is important in a vertical split
activePane NullableWorksheetWorksheetPane: Active pane in the split window.
The parameter is nullable

Exceptions

Exception	Condition
WorksheetException	WorksheetException Thrown if the column number of the top left cell is smaller the split panes number of columns from left, if freeze is applied