SheetXL - v0.8.0-beta.9+sites.210.e2d420901
    Preparing search index...

    Interface ICellHeaderRange

    Represents a collection of ICellHeaders.

    interface ICellHeaderRange {
        isICellHeaderRange: true;
        at(index: number): ICellHeader;
        clear(): this;
        doBatch<R>(
            callback: (commit: ICommit) => R | Promise<R>,
            options?: string | UpdateHeadersOptions,
        ): R | Promise<R>;
        forEach<T = any>(
            callback: ICellHeaderRange.ForEachCallback<T>,
            options?: ICellHeaderRange.IteratorOptions,
        ): void | T;
        forEachSpan<T = any>(
            callback: ForEachSpanCallback<T>,
            options?: ICellHeaderRange.IteratorOptions,
        ): void | T;
        getAddress(r1c1?: boolean): string;
        getAxis(): Axis;
        getCoords(): RunCoords;
        getCount(): number;
        getHeaderCount(): number;
        getSheetHeader<S>(): S;
        getSnapshot(
            options?: ICellHeaderRange.CopyOptions,
        ): ICellHeaderRange.ISnapshot;
        getUsedRange(options?: ICellHeaderRange.GetRangeOptions): this;
        getVisibleCount(): number;
        isEntireHeaders(): boolean;
        setHidden(hidden: boolean, options?: UpdateHeadersOptions): this;
        setSize(size: string | number, options?: SetSizeOptions): this;
        toString(): string;
        updateHeaders(
            values: ICellHeader.Update,
            options?: UpdateHeadersOptions,
        ): this;
    }
    Index
    isICellHeaderRange
    at clear doBatch forEach forEachSpan getAddress getAxis getCoords getCount getHeaderCount getSheetHeader getSnapshot getUsedRange getVisibleCount isEntireHeaders setHidden setSize toString updateHeaders
    isICellHeaderRange: true

    For runtime type checking.

    • Returns the header at a location relative to the range.

      Parameters

      • index: number

      Returns ICellHeader

    • Clear the header format. Specially this will clear the sizes.

      Returns this

    • Returns the coords as a string address (e.g., 'A1' or 'A1:E5').

      Parameters

      • Optionalr1c1: boolean

        If unspecified returns the environment's default.

      Returns string

    • Returns the header axis.

      Returns Axis

    • The RunCoords for the range.

      Returns RunCoords

    • Returns the number of headers included in the range.

      Returns number

    • Returns the number of headers.

      Returns number

    • Returns the SheetHeader.

      Type Parameters

      • S

      Returns S

    • Returns a snapshot of the current range's data and formatting suitable for copying or archiving.

      Parameters

      Returns ICellHeaderRange.ISnapshot

      A ISnapshot object representing the range.

      • Option Merging: If options are provided on getSnapshot and the copy operation, the two will be merged with the copy options taking precedence.
      • getSnapshot can be called multiple times allowing for multiple snapshots.

    • Returns the data ranges for headers that contain information.

      Parameters

      Returns this

      • This is NOT the last cell that may have data or has been resized.
      • This also has nothing to do with the selection bounds.

    • Returns the number of visible headers in the range.

      Returns number

    • Returns true if the range represents all headers.

      Returns boolean

    • Hides or show the columns for the given range.

      Parameters

      Returns this

      false

    • Returns the address as a string.

      Returns string

    Settings
    Member Visibility

    On This Page
    Properties
    Methods