Excel.Interfaces.RangeBorderData interface

An interface describing the data returned by calling rangeBorder.toJSON().

Properties

color

HTML color code representing the color of the border line, in the form #RRGGBB (e.g., "FFA500"), or as a named HTML color (e.g., "orange").

sideIndex

Constant value that indicates the specific side of the border. See Excel.BorderIndex for details.

style

One of the constants of line style specifying the line style for the border. See Excel.BorderLineStyle for details.

weight

Specifies the weight of the border around a range. See Excel.BorderWeight for details.

Property Details

color

HTML color code representing the color of the border line, in the form #RRGGBB (e.g., "FFA500"), or as a named HTML color (e.g., "orange").

color?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.1 ]

sideIndex

Constant value that indicates the specific side of the border. See Excel.BorderIndex for details.

sideIndex?: Excel.BorderIndex | "EdgeTop" | "EdgeBottom" | "EdgeLeft" | "EdgeRight" | "InsideVertical" | "InsideHorizontal" | "DiagonalDown" | "DiagonalUp";

Property Value

Excel.BorderIndex | "EdgeTop" | "EdgeBottom" | "EdgeLeft" | "EdgeRight" | "InsideVertical" | "InsideHorizontal" | "DiagonalDown" | "DiagonalUp"

Remarks

[ API set: ExcelApi 1.1 ]

style

One of the constants of line style specifying the line style for the border. See Excel.BorderLineStyle for details.

style?: Excel.BorderLineStyle | "None" | "Continuous" | "Dash" | "DashDot" | "DashDotDot" | "Dot" | "Double" | "SlantDashDot";

Property Value

Excel.BorderLineStyle | "None" | "Continuous" | "Dash" | "DashDot" | "DashDotDot" | "Dot" | "Double" | "SlantDashDot"

Remarks

[ API set: ExcelApi 1.1 ]

weight

Specifies the weight of the border around a range. See Excel.BorderWeight for details.

weight?: Excel.BorderWeight | "Hairline" | "Thin" | "Medium" | "Thick";

Property Value

Excel.BorderWeight | "Hairline" | "Thin" | "Medium" | "Thick"

Remarks

[ API set: ExcelApi 1.1 ]