Represents a Table within the FlexSheet control.
constructor(name: string, range: CellRange, style?: TableStyle, columns?: TableColumn[], options?: ITableOptions): Table
Initializes a new instance of the Table class.
The name of the table.
The range of the table.
The table style to use with the table. The default style is the 'TableStyleMedium9' built-in table style, if the style is omitted.
The columns of the table.
The options ITableOptions of the table.
Gets or sets a value that determines whether the first table column should have the style applied.
Gets or sets a value that determines whether the last table column should have the style applied.
Gets or sets the table name.
The table name is used to reference the table programmatically.
Gets or sets a value that determines whether banded row formatting is applied.
deleteRows(index: number, count?: number, shift?: boolean): void
Delete rows of Table.
The starting index of the deleting rows in Table.
The numbers of rows to delete. If not specified then one row will be deleted.
Indicates whether cells beneath the table should be shifted or not. If not specified cells beneath will be shifted.
getRange(section?: TableSection, column?: any): CellRange
Gets the range of the specific section and column on the relevant sheet that the table occupies.
The section of Table. If the section is omitted. It will get the range of entire table.
The column of Table. The column could be TableColumn instance, column name or column index. If the column is omitted. It will get the range for all columns in the table. If the section is null, the reference of the specific column includes the header row and the totals row if they are visible.
insertRows(index: number, count?: number, shift?: boolean): boolean
Insert rows into Table.
The position where new rows should be added in table.
The numbers of rows to add. If not specified then one row will be added.
Indicates whether cells beneath the table should be shifted or not. If not specified cells beneath will be shifted.