Row

Extends Array<Cell>. Contains cells with metadata and parent references.

import { Row } from "betterspread"

Methods

update()

update(opts: RowUpdateOpts): Promise<void>

Updates cells in this row via batch update.

RowUpdateOpts

Property	Type	Description
values	unknown[] | Record<string, unknown>	Array or object keyed by header
inputFormat?	ValueInputOption	"RAW" (default) or "USER_ENTERED"

clear()

clear(): Promise<void>

Clears all cell values in this row.

style()

style(style: Format): Promise<void>

Applies a Format to the entire row.

appendCell()

appendCell(value: unknown | unknown[]): Promise<void>

Appends cell(s) to the end of this row.

refetch()

refetch(): Promise<void>

Re-reads row data from the API and replaces local cells.

delete()

delete(): Promise<void>

Deletes the entire row from the sheet.

get()

get(col: string): Cell

Returns cell by column label. Returns virtual cell if column doesn't exist.

Accessors

row.getTab(): TabInstance
row.getRowIndex(): number

Properties

Index access	Returns
row[0]	First Cell
row["A"]	Cell at column A (via Proxy)
row.length	Number of cells