Click or drag to resize
PicoXLSX

WorksheetSetSplit(NullableInt32, NullableInt32, Boolean, CellAddress, WorksheetWorksheetPane) Method

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

Namespace: PicoXLSX
Assembly: PicoXLSX (in PicoXLSX.dll) Version: 3.4.5+6ab75fa9edd66571b0de8e574b48108101297ca1
Syntax
C#
Copy
public void SetSplit(
	int? numberOfColumnsFromLeft,
	int? numberOfRowsFromTop,
	bool freeze,
	CellAddress topLeftCell,
	WorksheetWorksheetPane activePane
)

Parameters

numberOfColumnsFromLeft  NullableInt32
Number of columns from left of the worksheet to the split line. The particular column widths are considered.
The parameter is nullable. If left null, the method acts identical to SetHorizontalSplit(Int32, Boolean, CellAddress, WorksheetWorksheetPane)
numberOfRowsFromTop  NullableInt32
Number of rows from top of the worksheet to the split line. The particular row heights are considered.
The parameter is nullable. If left null, the method acts identical to SetVerticalSplit(Int32, Boolean, CellAddress, WorksheetWorksheetPane)
freeze  Boolean
If true, all panes are frozen, otherwise remains movable
topLeftCell  CellAddress
Top Left cell address of the bottom right pane (if applicable)
activePane  WorksheetWorksheetPane
Active pane in the split window.
The parameter is nullable
See Also