[Root] / Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / Border Class / Style Property
Example


In This Topic
    Style Property (Border)
    In This Topic
    Gets or sets the style of the Border.
    Syntax
    'Declaration
     
    
    Public Property Style As LineStyle
    'Usage
     
    
    Dim instance As Border
    Dim value As LineStyle
     
    instance.Style = value
     
    value = instance.Style
    public LineStyle Style {get; set;}
    Remarks

    The default value is None.

    Note that if the Color property is not defined, it will automatically be set to Black.

    Example
    var workbook = Workbook.Create("test.xlsx" )
    
    // Get the first worksheet. A workbook contains at least 1 worksheet.
    var cellWorksheet = workbook.Worksheets[ 0 ];
    
    // Set cell content and Border styles.
    cellWorksheet.Cells[ "C5" ].Value = "Bottom";
    cellWorksheet.Cells[ "C5" ].Style.Borders[ BorderType.Bottom ].Style = LineStyle.Double;
    cellWorksheet.Cells[ "C5" ].Style.Borders[ BorderType.Bottom ].Color = Color.Red;
    
    cellWorksheet.Cells[ "C8" ].Value = "Top";
    cellWorksheet.Cells[ "C8" ].Style.Borders[ BorderType.Top ].Style = LineStyle.DashDot;
    
    cellWorksheet.Cells[ "C11" ].Value = "Right";
    cellWorksheet.Cells[ "C11" ].Style.Borders[ BorderType.Right ] = new Border() { Style = LineStyle.MediumDashed, Color = Color.Green };
    
    // 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