Interface TableModelValues

A unique table definition useful for filter auto-styling and connecting to data-sources.

See

ITableModel

interface TableModelValues {
    autoFilter?: AutoFilter;
    columns?: TableColumn[];
    displayName?: string;
    headerRowCount?: number;
    name: string;
    ref: CellRangeCoords;
    sortState?: any;
    styleInfo?: TableStyleInfo;
    totalsRowCount?: number;
}

Hierarchy (view full)

Properties

autoFilter? columns? displayName? headerRowCount? name ref sortState? styleInfo? totalsRowCount?

Properties

Optional autoFilter

autoFilter?: AutoFilter

Optional columns

columns?: TableColumn[]

Optional displayName

displayName?: string

A string representing the name of the table. This is the name that shall be used in formula references, and displayed in the UI to the spreadsheet user. This name shall not have any spaces in it, and it must be unique amongst all other displayNames and definedNames in the workbook. The character lengths and restrictions are the same as for definedNames.

See SpreadsheetML Reference - Workbook definedNames section for details.

Optional headerRowCount

headerRowCount?: number

An integer representing the number of header rows showing at the top of the table. 0 means that the header row is not shown

Default Value

1

name

name: string

The unique name of the table

ref

ref: CellRangeCoords

The range on the relevant sheet that the table occupies expressed using A1 style referencing. The reference shall include the totals row if it is shown

Optional sortState

sortState?: any

Optional styleInfo

styleInfo?: TableStyleInfo

If not specified than the default table style is used If the style name isn't valid then uses a 'none' style.

Optional totalsRowCount

totalsRowCount?: number

An integer representing the number of totals rows that shall be shown at the bottom of the table.

Default Value

0

Settings

Member Visibility

Theme

On This Page

autoFiltercolumnsdisplayNameheaderRowCountnamerefsortStatestyleInfototalsRowCount