BorderCollection

BorderCollection class

Encapsulates a collection of Border objects.

public class BorderCollection

Properties

Name Description
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

Name Description
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