Class BorderCollection

BorderCollection class

Encapsulates a collection of Border objects.

public class BorderCollection

Properties

NameDescription
DiagonalColor { get; set; }Gets or sets the Color of Diagonal lines.
DiagonalStyle { get; set; }Gets or sets the style of Diagonal lines.
Item { get; }Gets the Border element at the specified index.

Methods

NameDescription
SetColor(Color)Sets the Color of all borders in the collection.
SetStyle(CellBorderType)Sets the style of all borders of the collection.

Examples


[C#]

//Instantiating a Workbook object
Workbook workbook = new Workbook();

//Adding a new worksheet to the Excel object
workbook.Worksheets.Add();

//Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[0];

//Accessing the "A1" cell from the worksheet
Cell cell = worksheet.Cells["A1"];

//Adding some value to the "A1" cell
cell.PutValue("Visit Aspose!");

Style style = cell.GetStyle();

//Setting the line style of the top border
style.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thick;

//Setting the color of the top border
style.Borders[BorderType.TopBorder].Color = Color.Black;

//Setting the line style of the bottom border
style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thick;

//Setting the color of the bottom border
style.Borders[BorderType.BottomBorder].Color = Color.Black;

//Setting the line style of the left border
style.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thick;

//Setting the color of the left border
style.Borders[BorderType.LeftBorder].Color = Color.Black;

//Setting the line style of the right border
style.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thick;

//Setting the color of the right border
style.Borders[BorderType.RightBorder].Color = Color.Black;

cell.SetStyle(style);

//Saving the Excel file
workbook.Save("book1.xls");

[VB.NET]

'Instantiating a Workbook object
Dim workbook As Workbook = New Workbook()

'Adding a new worksheet to the Workbook object
workbook.Worksheets.Add()

'Obtaining the reference of the newly added worksheet by passing its sheet index
Dim worksheet As Worksheet = workbook.Worksheets(0)

'Accessing the "A1" cell from the worksheet
Dim cell As Cell = worksheet.Cells("A1")

'Adding some value to the "A1" cell
cell.PutValue("Visit Aspose!")

Dim style as Style = cell.GetStyle()

'Setting the line style of the top border
style.Borders(BorderType.TopBorder).LineStyle = CellBorderType.Thick

'Setting the color of the top border
style.Borders(BorderType.TopBorder).Color = Color.Black

'Setting the line style of the bottom border
style.Borders(BorderType.BottomBorder).LineStyle = CellBorderType.Thick

'Setting the color of the bottom border
style.Borders(BorderType.BottomBorder).Color = Color.Black

'Setting the line style of the left border
style.Borders(BorderType.LeftBorder).LineStyle = CellBorderType.Thick

'Setting the color of the left border
style.Borders(BorderType.LeftBorder).Color = Color.Black

'Setting the line style of the right border
style.Borders(BorderType.RightBorder).LineStyle = CellBorderType.Thick

'Setting the color of the right border
style.Borders(BorderType.RightBorder).Color = Color.Black

cell.SetStyle(style)

'Saving the Excel file
workbook.Save("book1.xls")

See Also