Excel.Interfaces.ConditionalRangeBorderCollectionLoadOptions interface

Represents the border objects that make up range border.

Remarks

[ API set: ExcelApi 1.6 ]

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

color

For EACH ITEM in the collection: 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

For EACH ITEM in the collection: Constant value that indicates the specific side of the border. See Excel.ConditionalRangeBorderIndex for details.

style

For EACH ITEM in the collection: One of the constants of line style specifying the line style for the border. See Excel.BorderLineStyle for details.

Property Details

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

color

For EACH ITEM in the collection: 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?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]

sideIndex

For EACH ITEM in the collection: Constant value that indicates the specific side of the border. See Excel.ConditionalRangeBorderIndex for details.

sideIndex?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]

style

For EACH ITEM in the collection: One of the constants of line style specifying the line style for the border. See Excel.BorderLineStyle for details.

style?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]