Hierarchy

Hierarchy

  • Base
    • WorksheetTableStyle

Implements

Constructors

  • Parameters

    • name: string

    Returns WorksheetTableStyle

  • Parameters

    • name: string
    • isCustom: boolean

    Returns WorksheetTableStyle

  • Parameters

    • Rest ..._rest: any[]

    Returns WorksheetTableStyle

Properties

$type: Type
$t: Type
nextHashCode: number

Accessors

  • get alternateColumnStripeWidth(): number
  • Gets or sets the number of columns which will span each alternate column stripe.

    The stripe sizes must be between 1 and 9, inclusive.

    The column stripes are assigned from left to right in the table, first assigning the column stripe, then the alternate column stripe, then repeating.

    The alternate column stripe format is defined in the areaFormats collection and keyed by the WorksheetTableStyleArea.AlternateColumnStripe value.

    The number of columns which will span each alternate column stripe.

    Throws

    InvalidOperationException The value is set and isCustom is False, indicating that the style is a read-only, standard table style.

    Throws

    ArgumentOutOfRangeException The value assigned is less than 1 or greater than 9.

    See

    columnStripeWidth

    Returns number

  • set alternateColumnStripeWidth(a: number): void
  • Parameters

    • a: number

    Returns void

  • get alternateRowStripeHeight(): number
  • Gets or sets the number of rows which will span each alternate row stripe.

    The stripe sizes must be between 1 and 9, inclusive.

    The row stripes are assigned from top to bottom in the table, first assigning the row stripe, then the alternate row stripe, then repeating.

    The alternate row stripe format is defined in the areaFormats collection and keyed by the WorksheetTableStyleArea.AlternateRowStripe value.

    The number of rows which will span each alternate row stripe.

    Throws

    InvalidOperationException The value is set and isCustom is False, indicating that the style is a read-only, standard table style.

    Throws

    ArgumentOutOfRangeException The value assigned is less than 1 or greater than 9.

    See

    rowStripeHeight

    Returns number

  • set alternateRowStripeHeight(a: number): void
  • Parameters

    • a: number

    Returns void

  • get columnStripeWidth(): number
  • Gets or sets the number of columns which will span each column stripe.

    The stripe sizes must be between 1 and 9, inclusive.

    The column stripes are assigned from left to right in the table, first assigning the column stripe, then the alternate column stripe, then repeating.

    The column stripe format is defined in the areaFormats collection and keyed by the WorksheetTableStyleArea.ColumnStripe value.

    The number of columns which will span each column stripe.

    Throws

    InvalidOperationException The value is set and isCustom is False, indicating that the style is a read-only, standard table style.

    Throws

    ArgumentOutOfRangeException The value assigned is less than 1 or greater than 9.

    See

    alternateColumnStripeWidth

    Returns number

  • set columnStripeWidth(a: number): void
  • Parameters

    • a: number

    Returns void

  • get isCustom(): boolean
  • Gets the value indicating whether the style is a custom style. True id this is a custom table style; False if this is a read-only, standard table style.

    Returns boolean

  • get name(): string
  • Gets or sets the name of the style. The name of the style.

    Throws

    InvalidOperationException The value is set and isCustom is False, indicating that the style is a read-only, standard table style.

    Throws

    ArgumentException The value assigned is null, empty, or greater than 255 characters in length.

    Throws

    ArgumentException The value assigned matches the name of another custom style in the owning Workbook.customTableStyles collection. Table names are compared case-insensitively.

    Returns string

  • set name(a: string): void
  • Parameters

    • a: string

    Returns void

  • get rowStripeHeight(): number
  • Gets or sets the number of rows which will span each row stripe.

    The stripe sizes must be between 1 and 9, inclusive.

    The row stripes are assigned from top to bottom in the table, first assigning the row stripe, then the alternate row stripe, then repeating.

    The row stripe format is defined in the areaFormats collection and keyed by the WorksheetTableStyleArea.RowStripe value.

    The number of rows which will span each row stripe.

    Throws

    InvalidOperationException The value is set and isCustom is False, indicating that the style is a read-only, standard table style.

    Throws

    ArgumentOutOfRangeException The value assigned is less than 1 or greater than 9.

    See

    alternateRowStripeHeight

    Returns number

  • set rowStripeHeight(a: number): void
  • Parameters

    • a: number

    Returns void

Methods

  • Duplicates the style and returns a deep copy.

    A cloned style must be added to the Workbook.customTableStyles collection before it can be applied to a WorksheetTable.

    The only value not cloned from the style is the isCustom value. Cloning a standard style creates a custom style with the same style settings which can then be changed.

    Throws

    ArgumentNullException 'name' is null or empty.

    Returns

    The clone of the style.

    Parameters

    • name: string

      The name to give to the cloned style.

    Returns WorksheetTableStyle

  • Parameters

    • other: any

    Returns boolean

  • Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • 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