Returns or sets the row number where the worksheet is split into panes (the number of rows above the split).

[Visual Basic]
Property SplitRow As Double
[C#]
double SplitRow { get; set; }
[C++]
__property double get_SplitRow();
__property void set_SplitRow(double );
[JScript]
function get SplitRow() : double
function set SplitRow(double);

Example

This example splits the worksheet one so that there are 5 rows above the split line.

[C#]
book.Worksheets[1].SplitRow = 5;

[Visual Basic]
book.Worksheets(1).SplitRow = 5

[C++]
book->Worksheets->Item[1]->SplitRow = 5;

See Also

IWorksheet Interface | NativeExcel Namespace | Split Property | FreezePanes Property | SplitColumn Property

---