Tag: #data-table
2 articles
-
Pivot Tables in a JavaScript Spreadsheet — Live Cross-Tab Summaries in a Few Lines
Turn a few hundred rows of raw records into a cross-tab summary that recomputes as the data changes. One createPivot call declares rows, columns, and aggregations; the handle's update / refresh / remove drive it from code. A full worked example with region × product sales, plus filters, grand totals, and the Lite-vs-Pro line.
-
Sort & Filter a JavaScript Spreadsheet — Excel-Style AutoFilter, by Click and in Code
Add Excel-style column sorting and header-dropdown filters to a data table in the browser. One createAutoFilter call gives users the dropdowns; getColumnValues / setColumnFilter drive the same filters from code. A full worked example with a live visible-row counter, plus the sort-vs-filter and Lite-vs-Pro details.