NativeExcel for .Net Developer's Reference

IWorksheet.SplitRow Property

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

[Visual Basic]
PropertySplitRowAsDouble
[C#]
doubleSplitRow{get;set;}
[C++]
__propertydoubleget_SplitRow();
__propertyvoidset_SplitRow(double);
[JScript]
functiongetSplitRow():double
functionsetSplitRow(double);

Example

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

[C#]
book.Worksheets[1].SplitRow = 5;
[VisualBasic]
book.Worksheets(1).SplitRow = 5
[C++]
book->Worksheets->Item[1]->SplitRow = 5;

See Also

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