Abstract base class for the fill of a cell.

CellFill

new CellFill(): CellFill

Returns CellFill

$t: Type

Gets the default cell fill, which is no background color.

get noColor(): CellFill

Returns CellFill

Creates a linear gradient that can be applied to a cell's fill.

createLinearGradientFill(angle: number, stops: CellFillGradientStop[]): CellFillLinearGradient

Parameters

  • angle: number

    The angle, in degrees, of the direction of the linear gradient, going clockwise from the left-to-right direction.

  • stops: CellFillGradientStop[]

    Two or more gradient stops which describe the color transitions and their positions within the gradient.

Returns CellFillLinearGradient

Creates a solid color or pattern fill that can be applied to a cell.

createPatternFill(backgroundColorInfo: WorkbookColorInfo, patternColorInfo: WorkbookColorInfo, patternStyle: FillPatternStyle): CellFillPattern

Parameters

  • backgroundColorInfo: WorkbookColorInfo

    A [[WorkbookColorInfo]] which describes the background color of the cell, which will only be seen if the 'patternStyle' is not None.

  • patternColorInfo: 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: FillPatternStyle

    The fill pattern for the cell.

Returns CellFillPattern

Creates a rectangular gradient that can be applied to a cell's fill.

createRectangularGradientFill(colorInfo1: WorkbookColorInfo, colorInfo2: WorkbookColorInfo): CellFillRectangularGradient

Parameters

  • colorInfo1: WorkbookColorInfo

    A [[WorkbookColorInfo]] which describes the color at the inner rectangle (cell center) of the gradient.

  • colorInfo2: WorkbookColorInfo

    A [[WorkbookColorInfo]] which describes the color at the outer rectangle (cell edges) of the gradient.

Returns CellFillRectangularGradient

Creates a solid color fill that can be applied to a cell.

createSolidFill(solidColorInfo: WorkbookColorInfo): CellFillPattern

Parameters

  • solidColorInfo: WorkbookColorInfo

    A [[WorkbookColorInfo]] which describes the solid color of the fill.

Returns CellFillPattern