Excel.Interfaces.RangeBorderUpdateData interface

An interface for updating data on the RangeBorder object, for use in rangeBorder.set({ ... }).

Properties

color

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

[ 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.

[ API set: ExcelApi 1.1 ]

tintAndShade

Returns or sets a double that lightens or darkens a color for Range Border, the value is between -1 (darkest) and 1 (brightest), with 0 for the original color. A null value indicates that the border doesn't have uniform tintAndShade setting.

[ API set: ExcelApi 1.9 ]

weight

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

[ API set: ExcelApi 1.1 ]

Property Details

color

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

[ API set: ExcelApi 1.1 ]

color?: string;

Property Value

string

style

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

[ API set: ExcelApi 1.1 ]

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

Property Value

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

tintAndShade

Returns or sets a double that lightens or darkens a color for Range Border, the value is between -1 (darkest) and 1 (brightest), with 0 for the original color. A null value indicates that the border doesn't have uniform tintAndShade setting.

[ API set: ExcelApi 1.9 ]

tintAndShade?: number;

Property Value

number

weight

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

[ API set: ExcelApi 1.1 ]

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

Property Value

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