constructor(name: string, range: CellRange, style?: TableStyle, columns?: TableColumn[], options?: ITableOptions): Table
Tableクラスの新しいインスタンスを初期化します。
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.
deleteRows(index: number, count?: number, shift?: boolean): void
テーブルの行を削除します。
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
テーブルが占める関連シートの特定のセクションと列の範囲を取得します。
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
テーブルに行を挿入します。
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.
FlexSheetコントロール内のシートを表します。