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.2+7f12a949130e0be1e987e553d2d08c083176cdca

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