BorderCollection

BorderCollection class

Encapsulates a collection of Border objects.

class BorderCollection;

Example

const { Workbook, BorderType, CellBorderType, Color, SaveFormat } = AsposeCells;

//Instantiating a Workbook object
var workbook = new Workbook();
//Obtaining the reference of the newly added worksheet by passing its sheet index
var worksheet = workbook.worksheets.get(0);
//Accessing the "A1" cell from the worksheet
var cell = worksheet.cells.get("A1");
//Adding some value to the "A1" cell
cell.putValue("Visit Aspose!");
//Get style object from cell
var style = cell.getStyle();
//Setting the line style of the top border
style.borders.get(BorderType.TopBorder).lineStyle = CellBorderType.Thick;
//Setting the color of the top border
style.borders.get(BorderType.TopBorder).color = Color.Black;
//Setting the line style of the bottom border
style.borders.get(BorderType.BottomBorder).lineStyle = CellBorderType.Thick;
//Setting the color of the bottom border
style.borders.get(BorderType.BottomBorder).color = Color.Black;
//Setting the line style of the left border
style.borders.get(BorderType.LeftBorder).lineStyle = CellBorderType.Thick;
//Setting the color of the left border
style.borders.get(BorderType.LeftBorder).color = Color.Black;
//Setting the line style of the right border
style.borders.get(BorderType.RightBorder).lineStyle = CellBorderType.Thick;
//Setting the color of the right border
style.borders.get(BorderType.RightBorder).color = Color.Black;
//Set style object to cell
cell.setStyle(style);

//Saving the Excel file
var uint8Array = workbook.save(SaveFormat.Xlsx);

Properties

Property	Type	Description
diagonalColor	Color	Gets or sets the Color of Diagonal lines.
diagonalStyle	CellBorderType	Gets or sets the style of Diagonal lines.

Methods

Method	Description
get(BorderType)	Gets the Border element at the specified index.
setColor(Color)	Sets the Color of all borders in the collection.
setStyle(CellBorderType)	Sets the style of all borders of the collection.

diagonalColor

Gets or sets the Color of Diagonal lines.

diagonalColor : Color;

diagonalStyle

Gets or sets the style of Diagonal lines.

diagonalStyle : CellBorderType;

get(BorderType)

Gets the Border element at the specified index.

get(borderType: BorderType) : Border;

Parameters:

Parameter	Type	Description
borderType	BorderType	The border to be retrieved.

Returns

The element at the specified index.

setColor(Color)

Sets the Color of all borders in the collection.

setColor(color: Color) : void;

Parameters:

Parameter	Type	Description
color	Color	Borders’ Color.

setStyle(CellBorderType)

Sets the style of all borders of the collection.

setStyle(style: CellBorderType) : void;

Parameters:

Parameter	Type	Description
style	CellBorderType	Borders’ style