SheetXL - v1.0.2
    Preparing search index...

    Interface Properties

    A set of values that can be set on a ITable.

    ITable

    interface Properties {
        altText?: string;
        altTextSummary?: string;
        autoExpand?: ITable.AutoExpand;
        columns?: (string | ColumnProperties)[];
        description?: string;
        disabledColumnFill?: boolean;
        formulaBelow?: ITable.FormulaBelow;
        headerRowCount?: number;
        id?: string;
        name?: string;
        style?: string | ITableStyle.StyleOptions;
        totalsRowCount?: number;
        totalsRowShown?: boolean;
    }
    Index
    altText? altTextSummary? autoExpand? columns? description? disabledColumnFill? formulaBelow? headerRowCount? id? name? style? totalsRowCount? totalsRowShown?
    altText?: string

    Accessibility alt text for the table.

    altTextSummary?: string

    Accessibility alt text summary for the table.

    autoExpand?: ITable.AutoExpand

    Which edges of the table grow when something is entered just beside it.

    ITable.AutoExpand.Both

    columns?: (string | ColumnProperties)[]

    Table column definitions.

    All tables must have columns.

    description?: string

    Free text describing the table, such as what it holds. Not used in formulas.

    disabledColumnFill?: boolean

    If true a formula entered into a column is not filled down it.

    formulaBelow?: ITable.FormulaBelow

    Where a formula entered in the row just below the table goes.

    ITable.FormulaBelow.TotalsRow

    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.

    1
    id?: string

    A unique id for all tables in the workbook.

    This will never change.

    name?: string

    The unique name of the table.

    style?: string | ITableStyle.StyleOptions

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

    totalsRowCount?: number

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

    0
    totalsRowShown?: boolean

    Whether the table has ever shown a totals row.

    The first time a totals row is shown the last column is given a total - a sum when the column holds only numbers, a count otherwise. A table that has already shown one keeps whatever its columns had when the row was hidden, including nothing.

    false

    Settings
    Member Visibility

    On This Page
    Properties