HN Explorer

Show HN: Datagridxl2.js – No-nonsense fast Excel-like data table library (datagridxl.com)

1 points by robbiejs ↗ HN
Hello HN,

I’m Robbert, the creator of DataGridXL.js. After 1,5 years of hard work I have just released version 2.

DataGridXL is a free (and commercial) editable data table library written in ES6.

My goal is to develop the most performant & user-friendly spreadsheet-like data table out there:

- 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

Please take a look at the performance demo (https://www.datagridxl.com/demos/one-million-cells) to see the difference with other data grids out there. And let us know if you have any suggestions.

What's new in version 2:

* 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.

DataGridXL on Github: https://github.com/DataGridXL/DataGridXL2 DataGridXL on NPM: https://www.npmjs.com/package/@datagridxl/datagridxl2 DataGridXL Docs: https://datagridxl.com/docs

Please let me know if you have any suggestions or comments!

4 comments

[ 3.0 ms ] story [ 23.1 ms ] thread
mattewong
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?

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)

anyway, looks like a nice start-- good luck!

robbiejs
Handsontable is very slow and in a lot of cases unreliable. I noticed on their own forum and their Github issues that they have many unhappy users because of these issues. So I built something that is fast and reliable (it has its own store & state and repaint functions).

It is very extensible. You can change the Context Menu, change top bar and bottom bar parts. Change theme, etc. You should find most in the docs (perhaps spend more than 10 seconds?)

I am not trying to compete with Excel here. I am offering a data table component with an Excel-like interface. I don't recommend anyone to add a "edit 1,000,000 rows" screen in their web apps. Nothing wrong with pagination.

Thanks for your comment and let me know if you have any questions: robbert@datagridxl.com

robbiejs
Also, thank you for sharing your found bug. That should not happen and will be fixed this week.
robbiejs
Fixed already. Reload your browser to catch the latest version :-)