@jsfkit/types
    Preparing search index...

    Type Alias Table

    A tabular data structure.

    The metadata contained in a table can be used to resolve structured references and evaluate calculated columns.

    https://support.microsoft.com/office/f5ed2452-2337-4f71-bed3-c8ae6d2b276e

    type Table = {
        columns: TableColumn[];
        headerRowCount?: integer;
        name: string;
        ref: CellRange;
        sheet: string;
        style?: TableStyle;
        totalsRowCount?: integer;
    }
    Index

    Properties

    columns headerRowCount? name ref sheet style? totalsRowCount?

    Properties

    columns: TableColumn[]

    An array of column objects. They shall be ordered from left to right, so that the first column corresponds to the leftmost column in the referenced range and the last column corresponds to the rightmost column.

    headerRowCount?: integer

    A non-negative integer specifying the number of header rows at the top of the table. Default to 1 if absent.

    1
    name: string

    The name of the table. This name must adhere to the same restrictions as defined names in Excel. In particular, it cannot contain spaces.

    ref: CellRange

    A non-prefixed range reference to the area containing the table. The range shall include the column headers.

    sheet: string

    The name of the sheet in which the table is located.

    style?: TableStyle

    Presentation information for the table. When not present tables should be rendered using "TableStyleMedium2" style with TableStyle.showRowStripes set to true.

    totalsRowCount?: integer

    A non-negative integer specifying the number of totals rows at the bottom of the table. Default to 0 if absent.

    0

    Settings

    Member Visibility

    On This Page

    Properties