Get Started
Documentation

SetBorders

SetBorders(bordersIndex, lineStyle, color)

Set the border to the cell/cell range with the parameters specified.

Parameters:

Name Type Description
bordersIndex BordersIndex

Specifies the cell border position.

lineStyle LineStyle

Specifies the line style used to form the cell border.

color ApiColor

The color object previously created to set the color to the cell border.

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
oWorksheet.SetColumnWidth(0, 50);
oWorksheet.GetRange("A2").SetBorders("Bottom", "Thick", Api.CreateColorFromRGB(49, 133, 154));
oWorksheet.GetRange("A2").SetValue("This is a cell with a bottom border");
builder.SaveFile("xlsx", "SetBorders.xlsx");
builder.CloseFile();

Resulting document