SpreadJS 13
SpreadJS Documentation / Developer's Guide / Features / Manage Data Visualization and Objects / Tables / Create Tables
In This Topic
    Create Tables
    In This Topic

    You can display data in a table in the control. The table has options to filter or sort the data.

    Table

    The default table style is medium2.

    You can control whether to display the table header and footer by setting the showHeader and showFooter methods. You can control whether to highlight the first or last column by setting the highlightFirstColumn or highlightLastColumn method. You can control whether to show banded rows and columns by setting the bandRows or bandColumns method. You can customize the table style with the TableStyle class, headerRowStyle method, and the footerRowStyle method. You can set the header cell text and the footer cell text and formula.

    The row count for the table includes the header and footer rows. Tables support frozen rows and columns, sparklines, and cell spans.

    Using Code

    The following example creates a table and sets the table style.

    JavaScript
    Copy Code
    activeSheet.tables.add("Table1", 0, 0, 3, 3, GC.Spread.Sheets.Tables.TableThemes.dark1);
    activeSheet.getCell(0,0).text("Name");
    activeSheet.getCell(0,1).text("Value");
    activeSheet.getCell(0,2).text("T/F");
    activeSheet.getCell(1,0).text("AW");
    activeSheet.getCell(1,1).text("5");
    activeSheet.getCell(1,2).text("T");
    
    See Also