Ask HN: The best, preferably open source, JavaScript spreadsheet out there?

2 points by marto1 4y ago ↗ HN

Which one is the best and why ? Does it support data search ? Can it do validation ? Does it handle well with thousands and thousands of rows ? Are their docs full and up to date ?

I've been looking around at https://jspreadsheets.com/ and tried many of them, but still can't put my finger on which one to go with. My requirements are more on the viewing/grouping/searching side rather than editing/formulas etc. but any impressions will help.

3 comments

[ 0.27 ms ] story [ 17.1 ms ] thread

throwaway888abc 4y ago ↗

http://tabulator.info/ https://datatables.net/ https://gridjs.io/

https://www.ag-grid.com/

willcate 4y ago ↗

DataTables is solid.

codingdave 4y ago ↗

There is no one best answer for all use cases. Pick one that you like well enough to try, add some validation code into its events, and see how it goes.

FWIW, if you are talking about thousands of rows (or millions), it would be best to paginate, filter, and search on the server, with your grid just being a rendering widget. Doing it that way also makes your grid widget fairly replaceable, so choosing one should not be a blocking decision to starting to code it up.