Hello HN,<p>I’m Robbert, the creator of DataGridXL.js. After 1,5 years of hard work I have just released version 2.<p>DataGridXL is a free (and commercial) editable data table library written in ES6.<p>My goal is to develop the most performant & user-friendly spreadsheet-like data table out there:<p>- It has zero dependencies. You don’t need any framework to use DataGridXL.
- It is lightweight (~250kb) and easy to use. It does not even require messing with CSS.
- It has its own Virtual DOM implementation to prevent DOM errors.
- Developer friendly. Supports all modern web browsers<p>Please take a look at the performance demo (<a href="https://www.datagridxl.com/demos/one-million-cells" rel="nofollow">https://www.datagridxl.com/demos/one-million-cells</a>) to see the difference with other data grids out there. And let us know if you have any suggestions.<p>What's new in version 2:<p>* Rapidly search cells via top bar, just like Google Sheets.
* Freeze any amount of rows and/or columns.
* Hide and unhide rows and/or columns, just like in Google Sheets.
* Multi-Range Selection
* Fullscreen Mode
* Input bar at the bottom, so it works on touch devices too.<p>DataGridXL on Github: <a href="https://github.com/DataGridXL/DataGridXL2" rel="nofollow">https://github.com/DataGridXL/DataGridXL2</a>
DataGridXL on NPM: <a href="https://www.npmjs.com/package/@datagridxl/datagridxl2" rel="nofollow">https://www.npmjs.com/package/@datagridxl/datagridxl2</a>
DataGridXL Docs: <a href="https://datagridxl.com/docs" rel="nofollow">https://datagridxl.com/docs</a><p>Please let me know if you have any suggestions or comments!
I spent 10 seconds on it. looks pretty cool. But, some questions before I'd try to use it instead of jquery datatables or handsontable:
- why did you build it and what alternatives did you try first? What unmet need does it fulfill? how does it compare to other libs like handsontable or jquery datatables?
- how extensible is it? e.g. if I want to add custom context menus, custom locked / editable cells, etc
- how is the license enforced-- i.e. does it require internet connectivity to work?<p>Couple further comments:
- I tried copy + paste in your 1mm cells demo, and it didn't behave as expected (copied "n;m", pasted "n")
- 1mm cells isn't very much if you are touting performance. 100k rows with 500 columns each = 50,000,000 cells; that would be a better example if you are trying to show that your lib handles large tables well. And if you are trying to suggest that this could be compared to Excel, then 1mm rows with 1000 columns would be better (Excel supports 1,048,576 rows by 16,384 columns)<p>anyway, looks like a nice start-- good luck!