Class BorderCollection
Class BorderCollection
Namespace: Aspose.Cells
Assembly: Aspose.Cells.dll (25.2.0)
Encapsulates a collection of Aspose.Cells.Border objects.
public class BorderCollectionInheritance
Inherited Members
object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Examples
csharp
[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");
'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")Properties
DiagonalColor
Gets or sets the System.Drawing.Color of Diagonal lines.
public Color DiagonalColor { get; set; }Property Value
DiagonalStyle
Gets or sets the style of Diagonal lines.
public CellBorderType DiagonalStyle { get; set; }Property Value
this[BorderType]
Gets the Aspose.Cells.Border element at the specified index.
public Border this[BorderType borderType] { get; }Property Value
Methods
SetColor(Color)
Sets the System.Drawing.Color of all borders in the collection.
public void SetColor(Color color)Parameters
color Color
Borders’ System.Drawing.Color.
SetStyle(CellBorderType)
Sets the style of all borders of the collection.
public void SetStyle(CellBorderType style)Parameters
style CellBorderType
Borders’ style