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+3a069966d2787c42b695e5043a5e083b247634e3
Syntax
C#
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