Xceed Workbooks for .NET v2.0 Documentation
Borders Property (Style)
Example 


Xceed.Workbooks.NET Assembly > Xceed.Workbooks.NET Namespace > Style Class : Borders Property
Gets the collection of active Borders in a Style. Returns an empty collection by default.
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;}
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();
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

See Also

Reference

Style Class
Style Members