Style Property (Border)

Gets or sets the style of the Border. The default value is None.

Syntax

Visual Basic
C#

'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

If the Color property is not defined, Color 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();

Requirements

Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

Border Class
Border Members