Represents a style which can be applied to a [[WorksheetTable]].

WorksheetTableStyle

new WorksheetTableStyle(name: string): WorksheetTableStyle

Returns WorksheetTableStyle

Gets or sets the number of columns which will span each alternate column stripe.

get alternateColumnStripeWidth(): number

Returns number

set alternateColumnStripeWidth(a: number): void

Parameters

  • a: number

Returns void

Gets or sets the number of rows which will span each alternate row stripe.

get alternateRowStripeHeight(): number

Returns number

set alternateRowStripeHeight(a: number): void

Parameters

  • a: number

Returns void

Gets or sets the number of columns which will span each column stripe.

get columnStripeWidth(): number

Returns number

set columnStripeWidth(a: number): void

Parameters

  • a: number

Returns void

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.

get isCustom(): boolean

Returns boolean

Gets or sets the name of the style. The name of the style.

get name(): string

Returns string

set name(a: string): void

Parameters

  • a: string

Returns void

Gets or sets the number of rows which will span each row stripe.

get rowStripeHeight(): number

Returns number

set rowStripeHeight(a: number): void

Parameters

  • a: number

Returns void

Gets the format for the specified area. An [[IWorksheetCellFormat]] instance describing the appearance of the specified area.

areaFormats(area: WorksheetTableStyleArea): IWorksheetCellFormat

Parameters

Returns IWorksheetCellFormat

Duplicates the style and returns a deep copy.

clone(name: string): WorksheetTableStyle

Parameters

  • name: string

    The name to give to the cloned style.

Returns WorksheetTableStyle