Excel.Interfaces.ConditionalRangeBorderData interface

An interface describing the data returned by calling conditionalRangeBorder.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.ConditionalRangeBorderIndex for details.

style

One of the constants of line style specifying the line style for the border. See Excel.BorderLineStyle 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.6 ]

sideIndex

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

sideIndex?: Excel.ConditionalRangeBorderIndex | "EdgeTop" | "EdgeBottom" | "EdgeLeft" | "EdgeRight";

Property Value

Excel.ConditionalRangeBorderIndex | "EdgeTop" | "EdgeBottom" | "EdgeLeft" | "EdgeRight"

Remarks

[ API set: ExcelApi 1.6 ]

style

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

style?: Excel.ConditionalRangeBorderLineStyle | "None" | "Continuous" | "Dash" | "DashDot" | "DashDotDot" | "Dot";

Property Value

Excel.ConditionalRangeBorderLineStyle | "None" | "Continuous" | "Dash" | "DashDot" | "DashDotDot" | "Dot"

Remarks

[ API set: ExcelApi 1.6 ]