DataGridXL2 VS HANDSONTABLE

* Input bar at the bottom, so it works on touch devices too.

DataGridXL on Github: https://github.com/DataGridXL/DataGridXL2

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!

handsontable

There is also https://handsontable.com/

We are currently working on translating three new UI labels into 18 different languages. Can you help us out with it?

https://handsontable.com/ This is the best commercial library you can just buy and put it in your product.

I've always liked https://handsontable.com/ but I'm not sure what the licensing is for something other than a personal project.

trimWhitespace option can finally be used in columns and cells #7387,

All our packages are on npm, so depending on the framework you use, you can install it as follows:

Handsontable is primarily known as a JavaScript grid library for business apps but the decision to include it in this article is not accidental. Although this tool doesn't offer as many text formatting options as Excel, it includes quite a lot of features for manipulating data typical of spreadsheets. The list of the most widely used Handsontable features includes operations on rows & columns (moving, hiding, resizing, freezing), CRUD actions, non-contiguous selection, data validation, export to file, and merging cells. You can also take advantage of more advanced capabilities such as multi-column sorting, data summaries, trimming rows, and nested headers.