WorksheetSetHorizontalSplit(Int32, Boolean, Address, NullableWorksheetWorksheetPane) Method

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

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.3+98f265239ae8df4639650ecd7029244cc5e52dfc

Syntax

public void SetHorizontalSplit(
	int numberOfRowsFromTop,
	bool freeze,
	Address topLeftCell,
	WorksheetWorksheetPane? activePane
)

numberOfRowsFromTop Int32: Number of rows from top of the worksheet to the split line. The particular row heights 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 row component is important in a horizontal split
activePane NullableWorksheetWorksheetPane: Active pane in the split window.
The parameter is nullable

Exceptions

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