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

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.