GrapeCity.Documents.Excel.IWorksheet.SplitPanes

SplitPanes Method

Splits the worksheet into panes at the specified row and column positions.

Use this method to divide the worksheet view into multiple panes so that different areas of the worksheet can be viewed independently.

void SplitPanes(int row, int column)

Sub SplitPanes(row As Integer, column As Integer)

Type	Name	Description
int	row	The row position where the worksheet is split.
int	column	The column position where the worksheet is split.

worksheet.Range["A1"].Value = "Name";
worksheet.Range["B1"].Value = "Value";
worksheet.SplitPanes(2, 2);
IPanes panes = worksheet.Panes;