Demos · real data
The grids on a million real rows
Sample data with ten tidy rows hides the hard parts. These demos use the Online Retail II dataset, 1,067,371 invoice lines from a UK online shop between 2009 and 2011, with cancellations, postage lines and stock adjustments left in. Each one runs entirely in your browser; nothing is sent to a server.
- PivotGrid · FreeA pivot table on a million rows, measured while you dragDrag fields over 1,067,371 invoice lines; every recompute is timed in your browser, next to the same totals computed on the main thread.
- PivotGrid · FreeA sales report your users can rearrangeTop countries and their best sellers of 2011, with average price and share of the year. Click a value to see the invoice lines behind it.
- DataGrid + PivotGrid · EnterpriseSales dashboard on 1,067,371 real rowsA million transactions sorted, searched, grouped and pivoted in the browser, with no server behind it.
- DataGrid · FreeSelecting rows in a million, and what to send for themSelect everything a filter matches and see the selection as data: a filter and a few exceptions instead of a million ids.
- DataGrid · EnterpriseExport a million-row table to Excel, and check what arrivesNumbers that stay numbers, currency formats, collapsible groups, and the sheet row limit.
- DataGrid · EnterpriseEditing real order lines, and what a save sendsBatch editing over 240 order lines: validation, undo, and a log of the one request per changed row that each save sends.
Feature by feature
For a single feature on smaller sample data, with the code next to it and editable, use the playgrounds: the DataGrid playground and the PivotGrid playground. Speed claims are measured separately on the benchmarks page.