 | 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.7+3223c8b99fcd3402b4ae016daa480abac16f8a9f
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
Exceptions| Exception | Condition |
|---|
| WorksheetException | WorksheetException Thrown if the address of the top left cell is smaller the split panes address, if freeze is applied |
See Also