Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / SheetView Class / SplitRows Property
Example


In This Topic
    SplitRows Property
    In This Topic
    Gets or sets the number of Rows after which a horizontal split will appear in the Worksheet.
    Syntax
    'Declaration
 

    Public Property SplitRows As Integer
    'Usage
 

    Dim instance As SheetView
Dim value As Integer
 
instance.SplitRows = value
 
value = instance.SplitRows
    public int SplitRows {get; set;}
    Remarks

    Creating a split will divide the SheetView in two; afterwards, both sides of the split can be scrolled independently.

    The value must be between 0 and 1048576; a value of 2, for example, would create a split at the bottom of the second Row.

    The default value is 0, which doesn't create a split.

    Note that if the value of FrozenRows is greater than 0, this property will have no effect.

    Example
    Splits the worksheet horizontally after the 5th row and vertically after the first column:

using( var workbook = Workbook.Load( "test.xlsx" ) )
{
  // Splits horizontally after the first 5 rows and adds a Fill Background to them.
  worksheet.SheetView.SplitRows = 5;
  worksheet.Rows[ 0, 4 ].Style.Fill.BackgroundColor = System.Drawing.Color.Turquoise;

  // Splits vertically after the 1st column and adds a Fill Background to the first column.
  worksheet.SheetView.SplitColumns = 1;
  worksheet.Columns[ 0 ].Style.Fill.BackgroundColor = System.Drawing.Color.Tan;

  // Saves the workbook to disk.
  workbook.SaveAs( "SplitRowsColumns.xlsx" );
}
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also

    Reference

    SheetView Class
    SheetView Members

    Send Feedback