Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / Style Class / Borders Property
Example


In This Topic
    Borders Property (Style)
    In This Topic
    Gets the collection of active Borders in a Style.
    Syntax
    'Declaration
     
    
    Public ReadOnly Property Borders As BorderCollection
    'Usage
     
    
    Dim instance As Style
    Dim value As BorderCollection
     
    instance.Borders = value
     
    value = instance.Borders
    public BorderCollection Borders {get;}
    Remarks
    Returns an empty collection by default.
    Example
    var workbook = Workbook.Create( "test.xlsx" )
    
    // Get first worksheet.
    var worksheet = workbook.Worksheets[ 0 ];
    
    // Set cells content.
    worksheet.Cells[ "B15" ].Value = 0.1;
    
    worksheet.Cells[ "C15" ].Value = 0.22;
    worksheet.Cells[ "B16" ].Value = 0.31;
    worksheet.Cells[ "C16" ].Value = 0.5;
    worksheet.Cells[ "B17" ].Value = 0.36;
    worksheet.Cells[ "C17" ].Value = 0.25;
    
    // Get CellRange from B15 to C17 and modify the Borders of the 6 cells.
    var cellRange = worksheet.Cells[ "B15", "C17" ];
    cellRange.Style.Borders.SetInside( LineStyle.Medium, Color.DarkGreen );
    cellRange.Style.Borders.SetOutline( LineStyle.Medium, Color.DarkGreen );
    
    // Save workbook to disk.
    workbook.Save();
    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