Excel.Interfaces.RangeFillData interface
An interface describing the data returned by calling rangeFill.toJSON()
.
Properties
color | HTML color code representing the color of the background, in the form #RRGGBB (e.g., "FFA500"), or as a named HTML color (e.g., "orange") |
pattern | The pattern of a range. See |
pattern |
The HTML color code representing the color of the range pattern, in the form #RRGGBB (e.g., "FFA500"), or as a named HTML color (e.g., "orange"). |
pattern |
Specifies a double that lightens or darkens a pattern color for the range fill. The value is between -1 (darkest) and 1 (brightest), with 0 for the original color. A |
tint |
Specifies a double that lightens or darkens a color for the range fill. The value is between -1 (darkest) and 1 (brightest), with 0 for the original color. A |
Property Details
color
HTML color code representing the color of the background, in the form #RRGGBB (e.g., "FFA500"), or as a named HTML color (e.g., "orange")
color?: string;
Property Value
string
Remarks
pattern
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 a uniform pattern setting.
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"
Remarks
patternColor
The HTML color code representing the color of the range pattern, in the form #RRGGBB (e.g., "FFA500"), or as a named HTML color (e.g., "orange").
patternColor?: string;
Property Value
string
Remarks
patternTintAndShade
Specifies a double that lightens or darkens a pattern color for the range fill. The value is between -1 (darkest) and 1 (brightest), with 0 for the original color. A null
value indicates that the range doesn't have uniform patternTintAndShade
settings.
patternTintAndShade?: number;
Property Value
number
Remarks
tintAndShade
Specifies a double that lightens or darkens a color for the range fill. The value is between -1 (darkest) and 1 (brightest), with 0 for the original color. A null
value indicates that the range doesn't have uniform tintAndShade
settings.
tintAndShade?: number;
Property Value
number
Remarks
Office Add-ins