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
isOutline	boolean	Indicates if left, right, top, and bottom borders should be applied only to outside borders of a cell range. Default value is true.
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.

isOutline

Indicates if left, right, top, and bottom borders should be applied only to outside borders of a cell range. Default value is true.

isOutline : boolean;

Remarks

Only works when applying to a range for conditional formattings, pivot tables. If false,left, right, top, and bottom will apply to each cell, otherwise only to outside borders of a cell range. If true, please set horizontal and vertical border of inner borders of range for conditional formattings, pivot tables.

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