Excel.Interfaces.RangeFillData interface

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

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 ]

pattern

Gets or sets the pattern of a Range. See Excel.FillPattern for details. LinearGradient and RectangularGradient are not supported. A null value indicates that the entire range doesn't have uniform pattern setting.

[ API set: ExcelApi 1.9 ]

patternColor

Sets HTML color code representing the color of the Range pattern, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange"). Gets HTML color code representing the color of the Range pattern, of the form #RRGGBB (e.g. "FFA500").

[ API set: ExcelApi 1.9 ]

patternTintAndShade

Returns or sets a double that lightens or darkens a pattern color for Range Fill, the value is between -1 (darkest) and 1 (brightest), with 0 for the original color. If the pattern tintAndShades are not uniform, null will be returned.

[ API set: ExcelApi 1.9 ]

tintAndShade

Returns or sets a double that lightens or darkens a color for Range Fill, the value is between -1 (darkest) and 1 (brightest), with 0 for the original color. If the tintAndShades are not uniform, null will be returned.

[ API set: ExcelApi 1.9 ]

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

pattern

Gets or sets the pattern of a Range. See Excel.FillPattern for details. LinearGradient and RectangularGradient are not supported. A null value indicates that the entire range doesn't have uniform pattern setting.

[ API set: ExcelApi 1.9 ]

pattern?: Excel.FillPattern | "None" | "Solid" | "Gray50" | "Gray75" | "Gray25" | "Horizontal" | "Vertical" | "Down" | "Up" | "Checker" | "SemiGray75" | "LightHorizontal" | "LightVertical" | "LightDown" | "LightUp" | "Grid" | "CrissCross" | "Gray16" | "Gray8" | "LinearGradient" | "RectangularGradient";

Property Value

Excel.FillPattern | "None" | "Solid" | "Gray50" | "Gray75" | "Gray25" | "Horizontal" | "Vertical" | "Down" | "Up" | "Checker" | "SemiGray75" | "LightHorizontal" | "LightVertical" | "LightDown" | "LightUp" | "Grid" | "CrissCross" | "Gray16" | "Gray8" | "LinearGradient" | "RectangularGradient"

patternColor

Sets HTML color code representing the color of the Range pattern, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange"). Gets HTML color code representing the color of the Range pattern, of the form #RRGGBB (e.g. "FFA500").

[ API set: ExcelApi 1.9 ]

patternColor?: string;

Property Value

string

patternTintAndShade

Returns or sets a double that lightens or darkens a pattern color for Range Fill, the value is between -1 (darkest) and 1 (brightest), with 0 for the original color. If the pattern tintAndShades are not uniform, null will be returned.

[ API set: ExcelApi 1.9 ]

patternTintAndShade?: number;

Property Value

number

tintAndShade

Returns or sets a double that lightens or darkens a color for Range Fill, the value is between -1 (darkest) and 1 (brightest), with 0 for the original color. If the tintAndShades are not uniform, null will be returned.

[ API set: ExcelApi 1.9 ]

tintAndShade?: number;

Property Value

number