DataGridXL — Features
NO KNOWN TOPIC
Compare with Handsontable & Jspreadsheet
On this page we will compare DataGridXL with two JavaScript Excel-like data grid components that you might have heard of.
Handsontable was the first-to-market and Jspreadsheet is a relatively new product. What makes DataGridXL different from these two products is its focus on performance and usability.
DataGridXL does not pretend to be a spreadsheet. DataGridXL is a spreadsheet-like data grid. This means we don't offer merged cells, formulas, individual cell border styles and pivot tables. Because of this, we are able offer the fastest, most user-friendly Excel-like data grid out there.
Comparing Performance
DataGridXL is known for its unbeaten performance. We're not talking about just scroll performance, but edit performance (update performance) and load performance as well.
In this Compare article, we'll take a look at the following measurements:
- Bundle Size (in kilobytes)
- First Render Time (in milliseconds)
- Sort Time (in milliseconds)
- Scroll Performance (in milliseconds)
Test Setup
All data grids in this test were given a viewport of 800 × 600 pixels with virtual rendering enabled according to product documentation, with a data set of 100,000 rows × 24 columns. Every column given a fixed width of 100px.
Tests were performed on a 2023 Mac Mini on Google Chrome.
Bundle Size
Smaller is better.
First Render Time
The surprising winner for the First Render Time test here is Handsontable. Our initial results for Handsontable were a shocking 2540ms. To improve this initial render performance for Handsontable, you need to set colWidths: 100.
Handsontable wins this test because it does not create an internal data store. On initialization, DataGridXL stores your data in its reliable data store, so that data store & state are always in sync with what you see on screen. Very much like React. This way, you're undo-and-redo actions do not come with unwanted surprises.
Sort Performance
When it comes to sorting 100,000 rows, DataGridXL is over 30 times faster than Handsontable and over 15 times faster than Jspreadsheet.
Scroll & Redraw Performance
We have recorded a user scroll action on all data grids.
Notice that DataGridXL is the only data grid that does it completely right.
Scrolling through a Jspreadsheet data grid, your cell selection will disappear until you stop scrolling.
Scrolling through a Handsontable data grid, your cell selection AND your cell data will disappear until you stop scrolling.
Scrolling though your Data GridXL instance? Scrolling is a stable 60FPS. Your data stays visible and so does your cell selection.
