LineFormat
LineFormat class
Represents all setting of the line.
class LineFormat extends FillFormat;
Constructors
Constructor | Description |
---|---|
constructor(FillFormat) | Constructs from a parent object convertible to this. |
Properties
Property | Type | Description |
---|---|---|
compoundType | MsoLineStyle | Specifies the line compound type. |
dashStyle | MsoLineDashStyle | Specifies the line dash type. |
capType | LineCapType | Specifies the ending caps. |
joinType | LineJoinType | Specifies the line join type. |
beginArrowheadStyle | MsoArrowheadStyle | Gets and sets the begin arrow type of the line. |
beginArrowheadWidth | MsoArrowheadWidth | Gets and sets the begin arrow width type of the line. |
beginArrowheadLength | MsoArrowheadLength | Gets and sets the begin arrow length type of the line. |
endArrowheadStyle | MsoArrowheadStyle | Gets and sets the end arrow type of the line. |
endArrowheadWidth | MsoArrowheadWidth | Gets and sets the end arrow width type of the line. |
endArrowheadLength | MsoArrowheadLength | Gets and sets the end arrow length type of the line. |
weight | number | Gets or sets the weight of the line in unit of points. |
fillType | FillType | Gets and sets fill type |
transparency | number | Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear). |
gradientFill | GradientFill | Readonly. Gets GradientFill object. |
textureFill | TextureFill | Readonly. Gets TextureFill object. |
solidFill | SolidFill | Readonly. Gets SolidFill object. |
patternFill | PatternFill | Readonly. Gets PatternFill object. |
gradientColorType | GradientColorType | Readonly. Returns the gradient color type for the specified fill. |
gradientStyle | GradientStyleType | Readonly. Returns the gradient style for the specified fill. |
gradientColor1 | Color | Readonly. Returns the gradient color 1 for the specified fill. |
gradientColor2 | Color | Readonly. Returns the gradient color 2 for the specified fill. |
gradientDegree | number | Readonly. Returns the gradient degree for the specified fill. Only applies for Excel 2007. |
gradientVariant | number | Readonly. Returns the gradient variant for the specified fill. Only applies for Excel 2007. |
presetColor | GradientPresetType | Readonly. Returns the gradient preset color for the specified fill. |
texture | TextureType | Represents the texture type for the specified fill. |
pattern | FillPattern | Represents an area’s display pattern. |
pictureFormatType | FillPictureType | Gets and sets the picture format type. |
scale | number | Gets and sets the picture format scale. |
imageData | Uint8Array | Gets and sets the picture image data. |
Methods
Method | Description |
---|---|
getCompoundType() | @deprecated. Please use the ‘compoundType’ property instead. Specifies the line compound type. |
setCompoundType(MsoLineStyle) | @deprecated. Please use the ‘compoundType’ property instead. Specifies the line compound type. |
getDashStyle() | @deprecated. Please use the ‘dashStyle’ property instead. Specifies the line dash type. |
setDashStyle(MsoLineDashStyle) | @deprecated. Please use the ‘dashStyle’ property instead. Specifies the line dash type. |
getCapType() | @deprecated. Please use the ‘capType’ property instead. Specifies the ending caps. |
setCapType(LineCapType) | @deprecated. Please use the ‘capType’ property instead. Specifies the ending caps. |
getJoinType() | @deprecated. Please use the ‘joinType’ property instead. Specifies the line join type. |
setJoinType(LineJoinType) | @deprecated. Please use the ‘joinType’ property instead. Specifies the line join type. |
getBeginArrowheadStyle() | @deprecated. Please use the ‘beginArrowheadStyle’ property instead. Gets and sets the begin arrow type of the line. |
setBeginArrowheadStyle(MsoArrowheadStyle) | @deprecated. Please use the ‘beginArrowheadStyle’ property instead. Gets and sets the begin arrow type of the line. |
getBeginArrowheadWidth() | @deprecated. Please use the ‘beginArrowheadWidth’ property instead. Gets and sets the begin arrow width type of the line. |
setBeginArrowheadWidth(MsoArrowheadWidth) | @deprecated. Please use the ‘beginArrowheadWidth’ property instead. Gets and sets the begin arrow width type of the line. |
getBeginArrowheadLength() | @deprecated. Please use the ‘beginArrowheadLength’ property instead. Gets and sets the begin arrow length type of the line. |
setBeginArrowheadLength(MsoArrowheadLength) | @deprecated. Please use the ‘beginArrowheadLength’ property instead. Gets and sets the begin arrow length type of the line. |
getEndArrowheadStyle() | @deprecated. Please use the ’endArrowheadStyle’ property instead. Gets and sets the end arrow type of the line. |
setEndArrowheadStyle(MsoArrowheadStyle) | @deprecated. Please use the ’endArrowheadStyle’ property instead. Gets and sets the end arrow type of the line. |
getEndArrowheadWidth() | @deprecated. Please use the ’endArrowheadWidth’ property instead. Gets and sets the end arrow width type of the line. |
setEndArrowheadWidth(MsoArrowheadWidth) | @deprecated. Please use the ’endArrowheadWidth’ property instead. Gets and sets the end arrow width type of the line. |
getEndArrowheadLength() | @deprecated. Please use the ’endArrowheadLength’ property instead. Gets and sets the end arrow length type of the line. |
setEndArrowheadLength(MsoArrowheadLength) | @deprecated. Please use the ’endArrowheadLength’ property instead. Gets and sets the end arrow length type of the line. |
getWeight() | @deprecated. Please use the ‘weight’ property instead. Gets or sets the weight of the line in unit of points. |
setWeight(number) | @deprecated. Please use the ‘weight’ property instead. Gets or sets the weight of the line in unit of points. |
getHashCode() | Gets the hash code. |
equals(Object) | Determines whether this instance has the same value as another specified LineFormat object. |
isNull() | Checks whether the implementation object is null. |
getFillType() | @deprecated. Please use the ‘fillType’ property instead. Gets and sets fill type |
setFillType(FillType) | @deprecated. Please use the ‘fillType’ property instead. Gets and sets fill type |
getTransparency() | @deprecated. Please use the ’transparency’ property instead. Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear). |
setTransparency(number) | @deprecated. Please use the ’transparency’ property instead. Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear). |
getGradientFill() | @deprecated. Please use the ‘gradientFill’ property instead. Gets GradientFill object. |
getTextureFill() | @deprecated. Please use the ’textureFill’ property instead. Gets TextureFill object. |
getSolidFill() | @deprecated. Please use the ‘solidFill’ property instead. Gets SolidFill object. |
getPatternFill() | @deprecated. Please use the ‘patternFill’ property instead. Gets PatternFill object. |
getGradientColorType() | @deprecated. Please use the ‘gradientColorType’ property instead. Returns the gradient color type for the specified fill. |
getGradientStyle() | @deprecated. Please use the ‘gradientStyle’ property instead. Returns the gradient style for the specified fill. |
getGradientColor1() | @deprecated. Please use the ‘gradientColor1’ property instead. Returns the gradient color 1 for the specified fill. |
getGradientColor2() | @deprecated. Please use the ‘gradientColor2’ property instead. Returns the gradient color 2 for the specified fill. |
getGradientDegree() | @deprecated. Please use the ‘gradientDegree’ property instead. Returns the gradient degree for the specified fill. Only applies for Excel 2007. |
getGradientVariant() | @deprecated. Please use the ‘gradientVariant’ property instead. Returns the gradient variant for the specified fill. Only applies for Excel 2007. |
getPresetColor() | @deprecated. Please use the ‘presetColor’ property instead. Returns the gradient preset color for the specified fill. |
getTexture() | @deprecated. Please use the ’texture’ property instead. Represents the texture type for the specified fill. |
setTexture(TextureType) | @deprecated. Please use the ’texture’ property instead. Represents the texture type for the specified fill. |
getPattern() | @deprecated. Please use the ‘pattern’ property instead. Represents an area’s display pattern. |
setPattern(FillPattern) | @deprecated. Please use the ‘pattern’ property instead. Represents an area’s display pattern. |
getPictureFormatType() | @deprecated. Please use the ‘pictureFormatType’ property instead. Gets and sets the picture format type. |
setPictureFormatType(FillPictureType) | @deprecated. Please use the ‘pictureFormatType’ property instead. Gets and sets the picture format type. |
getScale() | @deprecated. Please use the ‘scale’ property instead. Gets and sets the picture format scale. |
setScale(number) | @deprecated. Please use the ‘scale’ property instead. Gets and sets the picture format scale. |
getImageData() | @deprecated. Please use the ‘imageData’ property instead. Gets and sets the picture image data. |
setImageData(Uint8Array) | @deprecated. Please use the ‘imageData’ property instead. Gets and sets the picture image data. |
setOneColorGradient(Color, number, GradientStyleType, number) | Sets the specified fill to a one-color gradient. Only applies for Excel 2007. |
setTwoColorGradient(Color, Color, GradientStyleType, number) | Sets the specified fill to a two-color gradient. Only applies for Excel 2007. |
setTwoColorGradient(Color, number, Color, number, GradientStyleType, number) | Sets the specified fill to a two-color gradient. Only applies for Excel 2007. |
setPresetColorGradient(GradientPresetType, GradientStyleType, number) | Sets the specified fill to a preset-color gradient. Only applies for Excel 2007. |
constructor(FillFormat)
Constructs from a parent object convertible to this.
constructor(obj: FillFormat);
Parameters:
Parameter | Type | Description |
---|---|---|
obj | FillFormat | The parent object. |
compoundType
Specifies the line compound type.
compoundType : MsoLineStyle;
dashStyle
Specifies the line dash type.
dashStyle : MsoLineDashStyle;
capType
Specifies the ending caps.
capType : LineCapType;
joinType
Specifies the line join type.
joinType : LineJoinType;
beginArrowheadStyle
Gets and sets the begin arrow type of the line.
beginArrowheadStyle : MsoArrowheadStyle;
beginArrowheadWidth
Gets and sets the begin arrow width type of the line.
beginArrowheadWidth : MsoArrowheadWidth;
beginArrowheadLength
Gets and sets the begin arrow length type of the line.
beginArrowheadLength : MsoArrowheadLength;
endArrowheadStyle
Gets and sets the end arrow type of the line.
endArrowheadStyle : MsoArrowheadStyle;
endArrowheadWidth
Gets and sets the end arrow width type of the line.
endArrowheadWidth : MsoArrowheadWidth;
endArrowheadLength
Gets and sets the end arrow length type of the line.
endArrowheadLength : MsoArrowheadLength;
weight
Gets or sets the weight of the line in unit of points.
weight : number;
fillType
Gets and sets fill type
fillType : FillType;
transparency
Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).
transparency : number;
gradientFill
Readonly. Gets GradientFill object.
gradientFill : GradientFill;
textureFill
Readonly. Gets TextureFill object.
textureFill : TextureFill;
solidFill
Readonly. Gets SolidFill object.
solidFill : SolidFill;
patternFill
Readonly. Gets PatternFill object.
patternFill : PatternFill;
gradientColorType
Readonly. Returns the gradient color type for the specified fill.
gradientColorType : GradientColorType;
gradientStyle
Readonly. Returns the gradient style for the specified fill.
gradientStyle : GradientStyleType;
gradientColor1
Readonly. Returns the gradient color 1 for the specified fill.
gradientColor1 : Color;
gradientColor2
Readonly. Returns the gradient color 2 for the specified fill.
gradientColor2 : Color;
Remarks
Only when the gradient color type is GradientColorType.TwoColors, this property is meaningful.
gradientDegree
Readonly. Returns the gradient degree for the specified fill. Only applies for Excel 2007.
gradientDegree : number;
Remarks
Can only be a value from 0.0 (dark) through 1.0 (light).
gradientVariant
Readonly. Returns the gradient variant for the specified fill. Only applies for Excel 2007.
gradientVariant : number;
Remarks
Can only be a value from 1 through 4, corresponding to one of the four variants on the Gradient tab in the Fill Effects dialog box. If style is GradientStyle.FromCenter, the Variant argument can only be 1 or 2.
presetColor
Readonly. Returns the gradient preset color for the specified fill.
presetColor : GradientPresetType;
texture
Represents the texture type for the specified fill.
texture : TextureType;
pattern
Represents an area’s display pattern.
pattern : FillPattern;
pictureFormatType
Gets and sets the picture format type.
pictureFormatType : FillPictureType;
scale
Gets and sets the picture format scale.
scale : number;
imageData
Gets and sets the picture image data.
imageData : Uint8Array;
Remarks
If the fill format is not custom texture format, returns null.
getCompoundType()
@deprecated. Please use the ‘compoundType’ property instead. Specifies the line compound type.
getCompoundType() : MsoLineStyle;
Returns
setCompoundType(MsoLineStyle)
@deprecated. Please use the ‘compoundType’ property instead. Specifies the line compound type.
setCompoundType(value: MsoLineStyle) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | MsoLineStyle | The value to set. |
getDashStyle()
@deprecated. Please use the ‘dashStyle’ property instead. Specifies the line dash type.
getDashStyle() : MsoLineDashStyle;
Returns
setDashStyle(MsoLineDashStyle)
@deprecated. Please use the ‘dashStyle’ property instead. Specifies the line dash type.
setDashStyle(value: MsoLineDashStyle) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | MsoLineDashStyle | The value to set. |
getCapType()
@deprecated. Please use the ‘capType’ property instead. Specifies the ending caps.
getCapType() : LineCapType;
Returns
setCapType(LineCapType)
@deprecated. Please use the ‘capType’ property instead. Specifies the ending caps.
setCapType(value: LineCapType) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | LineCapType | The value to set. |
getJoinType()
@deprecated. Please use the ‘joinType’ property instead. Specifies the line join type.
getJoinType() : LineJoinType;
Returns
setJoinType(LineJoinType)
@deprecated. Please use the ‘joinType’ property instead. Specifies the line join type.
setJoinType(value: LineJoinType) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | LineJoinType | The value to set. |
getBeginArrowheadStyle()
@deprecated. Please use the ‘beginArrowheadStyle’ property instead. Gets and sets the begin arrow type of the line.
getBeginArrowheadStyle() : MsoArrowheadStyle;
Returns
setBeginArrowheadStyle(MsoArrowheadStyle)
@deprecated. Please use the ‘beginArrowheadStyle’ property instead. Gets and sets the begin arrow type of the line.
setBeginArrowheadStyle(value: MsoArrowheadStyle) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | MsoArrowheadStyle | The value to set. |
getBeginArrowheadWidth()
@deprecated. Please use the ‘beginArrowheadWidth’ property instead. Gets and sets the begin arrow width type of the line.
getBeginArrowheadWidth() : MsoArrowheadWidth;
Returns
setBeginArrowheadWidth(MsoArrowheadWidth)
@deprecated. Please use the ‘beginArrowheadWidth’ property instead. Gets and sets the begin arrow width type of the line.
setBeginArrowheadWidth(value: MsoArrowheadWidth) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | MsoArrowheadWidth | The value to set. |
getBeginArrowheadLength()
@deprecated. Please use the ‘beginArrowheadLength’ property instead. Gets and sets the begin arrow length type of the line.
getBeginArrowheadLength() : MsoArrowheadLength;
Returns
setBeginArrowheadLength(MsoArrowheadLength)
@deprecated. Please use the ‘beginArrowheadLength’ property instead. Gets and sets the begin arrow length type of the line.
setBeginArrowheadLength(value: MsoArrowheadLength) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | MsoArrowheadLength | The value to set. |
getEndArrowheadStyle()
@deprecated. Please use the ’endArrowheadStyle’ property instead. Gets and sets the end arrow type of the line.
getEndArrowheadStyle() : MsoArrowheadStyle;
Returns
setEndArrowheadStyle(MsoArrowheadStyle)
@deprecated. Please use the ’endArrowheadStyle’ property instead. Gets and sets the end arrow type of the line.
setEndArrowheadStyle(value: MsoArrowheadStyle) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | MsoArrowheadStyle | The value to set. |
getEndArrowheadWidth()
@deprecated. Please use the ’endArrowheadWidth’ property instead. Gets and sets the end arrow width type of the line.
getEndArrowheadWidth() : MsoArrowheadWidth;
Returns
setEndArrowheadWidth(MsoArrowheadWidth)
@deprecated. Please use the ’endArrowheadWidth’ property instead. Gets and sets the end arrow width type of the line.
setEndArrowheadWidth(value: MsoArrowheadWidth) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | MsoArrowheadWidth | The value to set. |
getEndArrowheadLength()
@deprecated. Please use the ’endArrowheadLength’ property instead. Gets and sets the end arrow length type of the line.
getEndArrowheadLength() : MsoArrowheadLength;
Returns
setEndArrowheadLength(MsoArrowheadLength)
@deprecated. Please use the ’endArrowheadLength’ property instead. Gets and sets the end arrow length type of the line.
setEndArrowheadLength(value: MsoArrowheadLength) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | MsoArrowheadLength | The value to set. |
getWeight()
@deprecated. Please use the ‘weight’ property instead. Gets or sets the weight of the line in unit of points.
getWeight() : number;
setWeight(number)
@deprecated. Please use the ‘weight’ property instead. Gets or sets the weight of the line in unit of points.
setWeight(value: number) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | number | The value to set. |
getHashCode()
Gets the hash code.
getHashCode() : number;
equals(Object)
Determines whether this instance has the same value as another specified LineFormat object.
equals(obj: Object) : boolean;
Parameters:
Parameter | Type | Description |
---|---|---|
obj | Object | The LineFormat object to compare with this instance. |
Returns
true if the value of the obj parameter is the same as the value of this instance; otherwise, false. If obj is null, this method returns false.
isNull()
Checks whether the implementation object is null.
isNull() : boolean;
getFillType()
@deprecated. Please use the ‘fillType’ property instead. Gets and sets fill type
getFillType() : FillType;
Returns
setFillType(FillType)
@deprecated. Please use the ‘fillType’ property instead. Gets and sets fill type
setFillType(value: FillType) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | FillType | The value to set. |
getTransparency()
@deprecated. Please use the ’transparency’ property instead. Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).
getTransparency() : number;
setTransparency(number)
@deprecated. Please use the ’transparency’ property instead. Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).
setTransparency(value: number) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | number | The value to set. |
getGradientFill()
@deprecated. Please use the ‘gradientFill’ property instead. Gets GradientFill object.
getGradientFill() : GradientFill;
Returns
getTextureFill()
@deprecated. Please use the ’textureFill’ property instead. Gets TextureFill object.
getTextureFill() : TextureFill;
Returns
getSolidFill()
@deprecated. Please use the ‘solidFill’ property instead. Gets SolidFill object.
getSolidFill() : SolidFill;
Returns
getPatternFill()
@deprecated. Please use the ‘patternFill’ property instead. Gets PatternFill object.
getPatternFill() : PatternFill;
Returns
getGradientColorType()
@deprecated. Please use the ‘gradientColorType’ property instead. Returns the gradient color type for the specified fill.
getGradientColorType() : GradientColorType;
Returns
getGradientStyle()
@deprecated. Please use the ‘gradientStyle’ property instead. Returns the gradient style for the specified fill.
getGradientStyle() : GradientStyleType;
Returns
getGradientColor1()
@deprecated. Please use the ‘gradientColor1’ property instead. Returns the gradient color 1 for the specified fill.
getGradientColor1() : Color;
Returns
getGradientColor2()
@deprecated. Please use the ‘gradientColor2’ property instead. Returns the gradient color 2 for the specified fill.
getGradientColor2() : Color;
Returns
Remarks
Only when the gradient color type is GradientColorType.TwoColors, this property is meaningful.
getGradientDegree()
@deprecated. Please use the ‘gradientDegree’ property instead. Returns the gradient degree for the specified fill. Only applies for Excel 2007.
getGradientDegree() : number;
Remarks
Can only be a value from 0.0 (dark) through 1.0 (light).
getGradientVariant()
@deprecated. Please use the ‘gradientVariant’ property instead. Returns the gradient variant for the specified fill. Only applies for Excel 2007.
getGradientVariant() : number;
Remarks
Can only be a value from 1 through 4, corresponding to one of the four variants on the Gradient tab in the Fill Effects dialog box. If style is GradientStyle.FromCenter, the Variant argument can only be 1 or 2.
getPresetColor()
@deprecated. Please use the ‘presetColor’ property instead. Returns the gradient preset color for the specified fill.
getPresetColor() : GradientPresetType;
Returns
getTexture()
@deprecated. Please use the ’texture’ property instead. Represents the texture type for the specified fill.
getTexture() : TextureType;
Returns
setTexture(TextureType)
@deprecated. Please use the ’texture’ property instead. Represents the texture type for the specified fill.
setTexture(value: TextureType) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | TextureType | The value to set. |
getPattern()
@deprecated. Please use the ‘pattern’ property instead. Represents an area’s display pattern.
getPattern() : FillPattern;
Returns
setPattern(FillPattern)
@deprecated. Please use the ‘pattern’ property instead. Represents an area’s display pattern.
setPattern(value: FillPattern) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | FillPattern | The value to set. |
getPictureFormatType()
@deprecated. Please use the ‘pictureFormatType’ property instead. Gets and sets the picture format type.
getPictureFormatType() : FillPictureType;
Returns
setPictureFormatType(FillPictureType)
@deprecated. Please use the ‘pictureFormatType’ property instead. Gets and sets the picture format type.
setPictureFormatType(value: FillPictureType) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | FillPictureType | The value to set. |
getScale()
@deprecated. Please use the ‘scale’ property instead. Gets and sets the picture format scale.
getScale() : number;
setScale(number)
@deprecated. Please use the ‘scale’ property instead. Gets and sets the picture format scale.
setScale(value: number) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | number | The value to set. |
getImageData()
@deprecated. Please use the ‘imageData’ property instead. Gets and sets the picture image data.
getImageData() : Uint8Array;
Remarks
If the fill format is not custom texture format, returns null.
setImageData(Uint8Array)
@deprecated. Please use the ‘imageData’ property instead. Gets and sets the picture image data.
setImageData(value: Uint8Array) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | number[] | The value to set. |
Remarks
If the fill format is not custom texture format, returns null.
setOneColorGradient(Color, number, GradientStyleType, number)
Sets the specified fill to a one-color gradient. Only applies for Excel 2007.
setOneColorGradient(color: Color, degree: number, style: GradientStyleType, variant: number) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
color | Color | One gradient color. |
degree | number | The gradient degree. Can be a value from 0.0 (dark) through 1.0 (light). |
style | GradientStyleType | Gradient shading style. |
variant | number | The gradient variant. Can be a value from 1 through 4, corresponding to one of the four variants on the Gradient tab in the Fill Effects dialog box. If style is GradientStyle.FromCenter, the Variant argument can only be 1 or 2. |
setTwoColorGradient(Color, Color, GradientStyleType, number)
Sets the specified fill to a two-color gradient. Only applies for Excel 2007.
setTwoColorGradient(color1: Color, color2: Color, style: GradientStyleType, variant: number) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
color1 | Color | One gradient color. |
color2 | Color | Two gradient color. |
style | GradientStyleType | Gradient shading style. |
variant | number | The gradient variant. Can be a value from 1 through 4, corresponding to one of the four variants on the Gradient tab in the Fill Effects dialog box. If style is GradientStyle.FromCenter, the Variant argument can only be 1 or 2. |
setTwoColorGradient(Color, number, Color, number, GradientStyleType, number)
Sets the specified fill to a two-color gradient. Only applies for Excel 2007.
setTwoColorGradient(color1: Color, transparency1: number, color2: Color, transparency2: number, style: GradientStyleType, variant: number) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
color1 | Color | One gradient color. |
transparency1 | number | The degree of transparency of the color1 as a value from 0.0 (opaque) through 1.0 (clear). |
color2 | Color | Two gradient color. |
transparency2 | number | The degree of transparency of the color2 as a value from 0.0 (opaque) through 1.0 (clear). |
style | GradientStyleType | Gradient shading style. |
variant | number | The gradient variant. Can be a value from 1 through 4, corresponding to one of the four variants on the Gradient tab in the Fill Effects dialog box. If style is GradientStyle.FromCenter, the Variant argument can only be 1 or 2. |
setPresetColorGradient(GradientPresetType, GradientStyleType, number)
Sets the specified fill to a preset-color gradient. Only applies for Excel 2007.
setPresetColorGradient(presetColor: GradientPresetType, style: GradientStyleType, variant: number) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
presetColor | GradientPresetType | Preset color type |
style | GradientStyleType | Gradient shading style. |
variant | number | The gradient variant. Can be a value from 1 through 4, corresponding to one of the four variants on the Gradient tab in the Fill Effects dialog box. If style is GradientStyle.FromCenter, the Variant argument can only be 1 or 2. |