Class FormulaRange

constructor

• new FormulaRange(row, col, rows, cols, read): FormulaRange

• Parameters

  • row: number

    first row (0-based)

  • col: number

    first column

  • rows: number

    number of rows (cut at the rows of the data)

  • cols: number

    number of columns

  • read: ((row, col) => SheetValue)

    reads a cell (sheet coordinates)

    • • (row, col): SheetValue

      • Parameters

        • row: number

        • col: number

        Returns SheetValue

  Returns FormulaRange

Readonly col

Readonly cols

Readonly row

Readonly rows

Readonly type

get

• get(r, c): SheetValue

• The value at a position inside the range.

  Parameters

  • r: number

    row inside the range (0-based)

  • c: number

    column inside the range

  Returns SheetValue

  the value (blank = null)

values

• values(): SheetValue[]

• Returns SheetValue[]

  all values, row by row