 | 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: NanoXLSXAssembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.4+e304ab0274fa680d1e83f83c8f76c3bd5a54caf2
Syntaxpublic 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
ExceptionsException | Condition |
---|
WorksheetException | WorksheetException Thrown if the address of the top left cell is smaller the split panes address, if freeze is applied |
See Also