Click or drag to resize
NanoXLSX

WorksheetSetSplit(NullableInt32, NullableInt32, Boolean, Address, NullableWorksheetWorksheetPane) 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: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.5+4f4b44a718a20dda8ca2c0c4d00bd7eee7c80f5d
Syntax
C#
public void SetSplit(
	int? numberOfColumnsFromLeft,
	int? numberOfRowsFromTop,
	bool freeze,
	Address 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, Address, NullableWorksheetWorksheetPane)
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, Address, NullableWorksheetWorksheetPane)
freeze  Boolean
If true, all panes are frozen, otherwise remains movable
topLeftCell  Address
Top Left cell address of the bottom right pane (if applicable)
activePane  NullableWorksheetWorksheetPane
Active pane in the split window.
The parameter is nullable
Exceptions
ExceptionCondition
WorksheetExceptionWorksheetException Thrown if the address of the top left cell is smaller the split panes address, if freeze is applied
See Also