(Showing Draft Content)

FlexSheet Tables

To make managing and analyzing a group of related data easier, you can turn a range of cells into a Table.

If you want to add an empty table, you need create a Table instance then add the Table instance into the tables collection of FlexSheet.

FlexSheet also allows to add table with data source by sheet.addTableFromArray method.

import * as wjFlexSheet from '@mescius/wijmo.grid.sheet';

let tableSheet = new wjFlexSheet.FlexSheet('#tableSheet');
tableSheet.addUnboundSheet('Table', 20, 7);
let tableStyle = tableSheet.getBuiltInTableStyle('TableStyleDark9');
tableSheet.selectedSheet.addTableFromArray(2, 1, getTableData(10), null, 'Table1', tableStyle, { showTotalRow: true });