Type Alias DataTable

Data table configuration, present on the master cell of a data table range. Represents an Excel What-If Analysis data table.

type DataTable = {
    dt2D?: boolean;
    dtr?: boolean;
    r1: CellId;
    r2?: CellId;
    ref: CellRange;
}

Properties

dt2D?: boolean

Whether this is a two-dimensional data table

dtr?: boolean

Whether one-dimensional data table is a row (true) or a column (false/absent)

Primary input cell reference to substitute

Secondary input cell reference, for 2D data tables

Range of cells the data table manages (e.g., "D3:D5")