Hierarchy

Hierarchy

Constructors

Properties

$type: Type
$t: Type
nextHashCode: number

Accessors

  • get noColor(): CellFill
  • Gets the default cell fill, which is no background color.

    Returns CellFill

Methods

  • Parameters

    • other: any

    Returns boolean

  • Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns number

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

    Throws

    ArgumentException 'stops' contains less than two gradient stops. There must be at least two stops to define the gradient.

    See

    CellFillLinearGradient

    Parameters

    • angle: number

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

    • Rest ...stops: CellFillGradientStop[]

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

    Returns CellFillLinearGradient

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

    Throws

    ArgumentException 'colorInfo1' or 'colorInfo2' is an automatic or a system color.

    See

    CellFillLinearGradient

    Parameters

    Returns CellFillLinearGradient

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

    Throws

    ArgumentException 'color1' or 'color2' are the empty or system colors or have a non-opaque alpha channel.

    See

    CellFillLinearGradient

    Parameters

    • angle: number

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

    • color1: string | Color

      The color at the start of the gradient.

    • color2: string | Color

      The color at the end of the gradient.

    Returns CellFillLinearGradient

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

    'backgroundColorInfo' and 'patternColorInfo' can be specified as null to use the default colors.

    Throws

    InvalidEnumArgumentException 'patternStyle' is Default or not defined in the FillPatternStyle enumeration.

    See

    CellFillPattern

    Parameters

    Returns CellFillPattern

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

    Throws

    ArgumentException 'backgroundColor' or 'patternColor' are the empty color or have a non-opaque alpha channel.

    Throws

    InvalidEnumArgumentException 'patternStyle' is Default or not defined in the FillPatternStyle enumeration.

    See

    CellFillPattern

    Parameters

    • backgroundColor: string | Color

      The background color of the cell, which will only be seen if the 'patternStyle' is not None.

    • patternColor: string | Color

      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.

    Throws

    ArgumentException 'colorInfo1' or 'colorInfo2' is an automatic or a system color.

    See

    CellFillRectangularGradient

    Parameters

    Returns CellFillRectangularGradient

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

    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.

    Throws

    ArgumentOutOfRangeException 'left', 'top', 'right', or 'bottom' are less than 0.0 or greater than 1.0.

    Throws

    ArgumentException 'stops' contains less than two gradient stops. There must be at least two stops to define the gradient.

    See

    CellFillRectangularGradient

    Parameters

    • left: 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: 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: 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: 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).

    • Rest ...stops: CellFillGradientStop[]

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

    Returns CellFillRectangularGradient

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

    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.

    Throws

    ArgumentException 'colorInfo1' or 'colorInfo2' is an automatic or a system color.

    Throws

    ArgumentOutOfRangeException 'left', 'top', 'right', or 'bottom' are less than 0.0 or greater than 1.0.

    See

    CellFillRectangularGradient

    Parameters

    • left: 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: 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: 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: 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: WorkbookColorInfo

      A WorkbookColorInfo which describes the color at the inner rectangle of the gradient.

    • colorInfo2: WorkbookColorInfo

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

    Returns CellFillRectangularGradient

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

    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.

    Throws

    ArgumentOutOfRangeException 'left', 'top', 'right', or 'bottom' are less than 0.0 or greater than 1.0.

    Throws

    ArgumentException 'color1' or 'color2' are empty or system colors or have a non-opaque alpha channel.

    See

    CellFillRectangularGradient

    Parameters

    • left: 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: 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: 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: 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: string | Color

      The color at the inner rectangle of the gradient.

    • color2: string | Color

      The color at the outer rectangle (cell edges) of the gradient.

    Returns CellFillRectangularGradient

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

    Throws

    ArgumentException 'color1' or 'color2' are empty or system colors or have a non-opaque alpha channel.

    See

    CellFillRectangularGradient

    Parameters

    • color1: string | Color

      The color at the inner rectangle (cell center) of the gradient.

    • color2: string | Color

      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.

    See

    CellFillPattern

    Parameters

    Returns CellFillPattern

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

    Throws

    ArgumentException 'solidColor' is the empty color or has a non-opaque alpha channel.

    See

    CellFillPattern

    Parameters

    • solidColor: string | Color

      The solid color of the fill.

    Returns CellFillPattern

  • Parameters

    • item1: any
    • item2: any

    Returns boolean

  • Parameters

    • a: any
    • b: any

    Returns boolean

  • Parameters

    • obj: any

    Returns any[]

  • Parameters

    • obj: any

    Returns any[]

  • Parameters

    • obj: any

    Returns number

  • Parameters

    • a: any
    • b: any

    Returns boolean