 | 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: PicoXLSXAssembly: PicoXLSX (in PicoXLSX.dll) Version: 3.4.5+3a069966d2787c42b695e5043a5e083b247634e3
Syntaxpublic 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