ig.excel.CellFill
Dependencies
-
ig.excel.CellFill
Constructor- new $.ig.excel.CellFill( );
-
createLinearGradientFill
- .createLinearGradientFill( angle:number, stops:ig.excel.CellFillGradientStop[] );
Creates a linear gradient that can be applied to a cell's fill.
- angle
- Type:number
- The angle, in degrees, of the direction of the linear gradient, going clockwise from the left-to-right direction.
- stops
- Type:ig.excel.CellFillGradientStop[]
- Two or more gradient stops which describe the color transitions and their positions within the gradient.
Exceptions
Exception Description ig.ArgumentException stops contains less than two gradient stops. There must be at least two stops to define the gradient. See Also
-
createLinearGradientFill
- .createLinearGradientFill( angle:number, colorInfo1:ig.excel.WorkbookColorInfo, colorInfo2:ig.excel.WorkbookColorInfo );
Creates a linear gradient that can be applied to a cell's fill.
- angle
- Type:number
- The angle, in degrees, of the direction of the linear gradient, going clockwise from the left-to-right direction.
- colorInfo1
- Type:ig.excel.WorkbookColorInfo
- A WorkbookColorInfo which describes the color at the start of the gradient.
- colorInfo2
- Type:ig.excel.WorkbookColorInfo
- A WorkbookColorInfo which describes the color at the end of the gradient.
Exceptions
Exception Description ig.ArgumentException colorInfo1 or colorInfo2 is an automatic or a system color. See Also
-
createLinearGradientFill
- .createLinearGradientFill( angle:number, color1:string, color2:string );
Creates a linear gradient that can be applied to a cell's fill.
- angle
- Type:number
- The angle, in degrees, of the direction of the linear gradient, going clockwise from the left-to-right direction.
- color1
- Type:string
- The color at the start of the gradient.
- color2
- Type:string
- The color at the end of the gradient.
Exceptions
Exception Description ig.ArgumentException color1 or color2 are the empty or system colors or have a non-opaque alpha channel. See Also
-
createPatternFill
- .createPatternFill( backgroundColorInfo:ig.excel.WorkbookColorInfo, patternColorInfo:ig.excel.WorkbookColorInfo, patternStyle:ig.excel.FillPatternStyle );
Creates a solid color or pattern fill that can be applied to a cell.
- backgroundColorInfo
- Type:ig.excel.WorkbookColorInfo
- A WorkbookColorInfo which describes the background color of the cell, which will only be seen if the patternStyle is not None.
- patternColorInfo
- Type:ig.excel.WorkbookColorInfo
- A WorkbookColorInfo which describes the pattern color of the cell, which will only be seen if the patternStyle is not None or Solid.
- patternStyle
- Type:ig.excel.FillPatternStyle
- The fill pattern for the cell.
Exceptions
Exception Description ig.excel.InvalidEnumArgumentException patternStyle is Default or not defined in the FillPatternStyle enumeration. Remarks
backgroundColorInfo and patternColorInfo can be specified as null to use the default colors.
See Also
-
createPatternFill
- .createPatternFill( backgroundColor:string, patternColor:string, patternStyle:ig.excel.FillPatternStyle );
Creates a solid color or pattern fill that can be applied to a cell.
- backgroundColor
- Type:string
- The background color of the cell, which will only be seen if the patternStyle is not None.
- patternColor
- Type:string
- The pattern color of the cell, which will only be seen if the patternStyle is not None or Solid.
- patternStyle
- Type:ig.excel.FillPatternStyle
- The fill pattern for the cell.
Exceptions
Exception Description ig.ArgumentException backgroundColor or patternColor are the empty color or have a non-opaque alpha channel. ig.excel.InvalidEnumArgumentException patternStyle is Default or not defined in the FillPatternStyle enumeration. See Also
-
createRectangularGradientFill
- .createRectangularGradientFill( colorInfo1:ig.excel.WorkbookColorInfo, colorInfo2:ig.excel.WorkbookColorInfo );
Creates a rectangular gradient that can be applied to a cell's fill.
- colorInfo1
- Type:ig.excel.WorkbookColorInfo
- A WorkbookColorInfo which describes the color at the inner rectangle (cell center) of the gradient.
- colorInfo2
- Type:ig.excel.WorkbookColorInfo
- A WorkbookColorInfo which describes the color at the outer rectangle (cell edges) of the gradient.
Exceptions
Exception Description ig.ArgumentException colorInfo1 or colorInfo2 is an automatic or a system color. See Also
-
createRectangularGradientFill
- .createRectangularGradientFill( left:number, top:number, right:number, bottom:number, stops:ig.excel.CellFillGradientStop[] );
Creates a rectangular gradient that can be applied to a cell's fill.
- left
- Type:number
- The left edge of the inner rectangle of the gradient, ranging from 0.0 (the left of the cell) to 1.0 (the right of the cell).
- top
- Type:number
- The top edge of the inner rectangle of the gradient, ranging from 0.0 (the top of the cell) to 1.0 (the bottom of the cell).
- right
- Type:number
- The right edge of the inner rectangle of the gradient, ranging from 0.0 (the left of the cell) to 1.0 (the right of the cell).
- bottom
- Type:number
- The bottom edge of the inner rectangle of the gradient, ranging from 0.0 (the top of the cell) to 1.0 (the bottom of the cell).
- stops
- Type:ig.excel.CellFillGradientStop[]
- Two or more gradient stops which describe the color transitions and their positions within the gradient.
Exceptions
Exception Description ig.ArgumentOutOfRangeException left, top, right, or bottom are less than 0.0 or greater than 1.0. ig.ArgumentException stops contains less than two gradient stops. There must be at least two stops to define the gradient. Remarks
The rectangular gradient is defined by specifying an inner rectangle and a set of gradient stops. The gradient goes from the edges of the inner rectangle to the edges of the cell. If the inner rectangle does not have a height or width of 0, the color of the first gradient stop will be filled in the center of the inner rectangle.
The inner rectangle is defined by the left, top, right, and bottom parameters. They are relative values ranging from 0.0 to 1.0 and they go from the top/left to the bottom/right. So, for example, to specify a gradient that goes out from the center, all values would be 0.5. Or to specify a gradient which goes out from the bottom-left corner of the cell, the following values would be used: left = 0.0, top = 1.0, right = 0.0, bottom = 1.0.
See Also
-
createRectangularGradientFill
- .createRectangularGradientFill( left:number, top:number, right:number, bottom:number, colorInfo1:ig.excel.WorkbookColorInfo, colorInfo2:ig.excel.WorkbookColorInfo );
Creates a rectangular gradient that can be applied to a cell's fill.
- left
- Type:number
- The left edge of the inner rectangle of the gradient, ranging from 0.0 (the left of the cell) to 1.0 (the right of the cell).
- top
- Type:number
- The top edge of the inner rectangle of the gradient, ranging from 0.0 (the top of the cell) to 1.0 (the bottom of the cell).
- right
- Type:number
- The right edge of the inner rectangle of the gradient, ranging from 0.0 (the left of the cell) to 1.0 (the right of the cell).
- bottom
- Type:number
- The bottom edge of the inner rectangle of the gradient, ranging from 0.0 (the top of the cell) to 1.0 (the bottom of the cell).
- colorInfo1
- Type:ig.excel.WorkbookColorInfo
- A WorkbookColorInfo which describes the color at the inner rectangle of the gradient.
- colorInfo2
- Type:ig.excel.WorkbookColorInfo
- A WorkbookColorInfo which describes the color at the outer rectangle (cell edges) of the gradient.
Exceptions
Exception Description ig.ArgumentException colorInfo1 or colorInfo2 is an automatic or a system color. ig.ArgumentOutOfRangeException left, top, right, or bottom are less than 0.0 or greater than 1.0. Remarks
The rectangular gradient is defined by specifying an inner rectangle and a set of gradient stops. The gradient goes from the edges of the inner rectangle to the edges of the cell. If the inner rectangle does not have a height or width of 0, the color of the first gradient stop will be filled in the center of the inner rectangle.
The inner rectangle is defined by the left, top, right, and bottom parameters. They are relative values ranging from 0.0 to 1.0 and they go from the top/left to the bottom/right. So, for example, to specify a gradient that goes out from the center, all values would be 0.5. Or to specify a gradient which goes out from the bottom-left corner of the cell, the following values would be used: left = 0.0, top = 1.0, right = 0.0, bottom = 1.0.
See Also
-
createRectangularGradientFill
- .createRectangularGradientFill( left:number, top:number, right:number, bottom:number, color1:string, color2:string );
Creates a rectangular gradient that can be applied to a cell's fill.
- left
- Type:number
- The left edge of the inner rectangle of the gradient, ranging from 0.0 (the left of the cell) to 1.0 (the right of the cell).
- top
- Type:number
- The top edge of the inner rectangle of the gradient, ranging from 0.0 (the top of the cell) to 1.0 (the bottom of the cell).
- right
- Type:number
- The right edge of the inner rectangle of the gradient, ranging from 0.0 (the left of the cell) to 1.0 (the right of the cell).
- bottom
- Type:number
- The bottom edge of the inner rectangle of the gradient, ranging from 0.0 (the top of the cell) to 1.0 (the bottom of the cell).
- color1
- Type:string
- The color at the inner rectangle of the gradient.
- color2
- Type:string
- The color at the outer rectangle (cell edges) of the gradient.
Exceptions
Exception Description ig.ArgumentOutOfRangeException left, top, right, or bottom are less than 0.0 or greater than 1.0. ig.ArgumentException color1 or color2 are empty or system colors or have a non-opaque alpha channel. Remarks
The rectangular gradient is defined by specifying an inner rectangle and a set of gradient stops. The gradient goes from the edges of the inner rectangle to the edges of the cell. If the inner rectangle does not have a height or width of 0, the color of the first gradient stop will be filled in the center of the inner rectangle.
The inner rectangle is defined by the left, top, right, and bottom parameters. They are relative values ranging from 0.0 to 1.0 and they go from the top/left to the bottom/right. So, for example, to specify a gradient that goes out from the center, all values would be 0.5. Or to specify a gradient which goes out from the bottom-left corner of the cell, the following values would be used: left = 0.0, top = 1.0, right = 0.0, bottom = 1.0.
See Also
-
createRectangularGradientFill
- .createRectangularGradientFill( color1:string, color2:string );
Creates a rectangular gradient that can be applied to a cell's fill.
- color1
- Type:string
- The color at the inner rectangle (cell center) of the gradient.
- color2
- Type:string
- The color at the outer rectangle (cell edges) of the gradient.
Exceptions
Exception Description ig.ArgumentException color1 or color2 are empty or system colors or have a non-opaque alpha channel. See Also
-
createSolidFill
- .createSolidFill( solidColorInfo:ig.excel.WorkbookColorInfo );
Creates a solid color fill that can be applied to a cell.
- solidColorInfo
- Type:ig.excel.WorkbookColorInfo
- A WorkbookColorInfo which describes the solid color of the fill.
See Also
-
createSolidFill
- .createSolidFill( solidColor:string );
Creates a solid color fill that can be applied to a cell.
- solidColor
- Type:string
- The solid color of the fill.
Exceptions
Exception Description ig.ArgumentException solidColor is the empty color or has a non-opaque alpha channel. See Also
-
noColor
- .noColor( );
Gets the default cell fill, which is no background color.