Excel.Interfaces.RangeBorderCollectionLoadOptions interface

Represents the border objects that make up the range border.

[ API set: ExcelApi 1.1 ]

Properties

$all
color

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

sideIndex

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

[ API set: ExcelApi 1.1 ]

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.

[ API set: ExcelApi 1.1 ]

tintAndShade

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

For EACH ITEM in the collection: Specifies the weight of the border around a range. See Excel.BorderWeight for details.

[ API set: ExcelApi 1.1 ]

Property Details

$all

$all?: boolean;

Property Value

boolean

color

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

Property Value

boolean

sideIndex

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

[ API set: ExcelApi 1.1 ]

sideIndex?: boolean;

Property Value

boolean

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.

[ API set: ExcelApi 1.1 ]

style?: boolean;

Property Value

boolean

tintAndShade

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

Property Value

boolean

weight

For EACH ITEM in the collection: Specifies the weight of the border around a range. See Excel.BorderWeight for details.

[ API set: ExcelApi 1.1 ]

weight?: boolean;

Property Value

boolean