WorksheetSetHorizontalSplit(Int32, Boolean, CellAddress, WorksheetWorksheetPane) Method

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

Namespace: PicoXLSX
Assembly: PicoXLSX (in PicoXLSX.dll) Version: 3.4.5+6ab75fa9edd66571b0de8e574b48108101297ca1

Syntax

public void SetHorizontalSplit(
	int numberOfRowsFromTop,
	bool freeze,
	CellAddress 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 CellAddress: Top Left cell address of the bottom right pane (if applicable). Only the row component is important in a horizontal split.
activePane WorksheetWorksheetPane: Active pane in the split window.