Abstract base class for worksheet row and worksheet column.

See

Hierarchy

Hierarchy

Implements

  • ICellFormatOwner
  • IWorksheetCellFormatProxyOwner

Constructors

Properties

$type: Type
$t: Type
nextHashCode: number

Accessors

  • get cellFormat(): IWorksheetCellFormat
  • Gets the default cell format for cells in this row or column.

    Any default properties of the cell's format will take their value from this format when getting a resolved format.

    The default cell format for cells in this row or column.

    Returns IWorksheetCellFormat

  • get hidden(): boolean
  • Gets or sets the value indicating whether the row or column is hidden. The Hidden state also controls the expanded state of rows or columns in outline groups. Basically, an outline group simply provides an easy way to hide and unhide all rows or columns in the group at the same time, via the expansion indicator. The value indicating whether the row or column is hidden.

    Throws

    InvalidOperationException From the stter if the object was removed from the worksheet.

    See

    Returns boolean

  • set hidden(a: boolean): void
  • Parameters

    • a: boolean

    Returns void

  • get index(): number
  • Gets the 0-based index of the row or column in the worksheet. The 0-based index of the row or column in the worksheet.

    Returns number

  • get outlineLevel(): number
  • Gets or sets the outline level for the row or column.

    Microsoft Excel supports hierarchical grouping of rows and columns with a maximum of seven levels of hierarchy. To create a group, set adjacent rows or columns to same outline level. When rows or columns are grouped, an outline indicator will provide a visual representation of the outline level. In addition, an outline group has an expansion indicator at one end of the group, which allows the user to easily hide and unhide all rows or column in the group with a single click.

    The outline level for the row or column.

    Throws

    ArgumentOutOfRangeException The value assigned is outside the valid outline level range of 0 and 7.

    Throws

    InvalidOperationException From the stter if the object was removed from the worksheet.

    See

    hidden

    Returns number

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

    • a: number

    Returns void

  • get worksheet(): Worksheet
  • Gets the worksheet to which the row or column belongs. The worksheet to which the row or column belongs.

    Returns Worksheet

Methods

  • Parameters

    • other: any

    Returns boolean

  • Returns number

  • Gets the resolved cell formatting for the cells in the row or column.

    Returns

    A format object describing the actual formatting that will be used when displayed the row or column in Microsoft Excel.

    Throws

    InvalidOperationException If the object was removed from the worksheet.

    See

    cellFormat

    Returns IWorksheetCellFormat

  • 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