Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: Datagridxl2.js – Fast Excel-like data table library

datagridxl.com

Post reply on HN
Print view View original

41–50 of 108 posts

Re: Show HN: Datagridxl2.js – Fast Excel-like data table library

#41

Post by tunesmith »

toastercat wrote: post #30

What's a good FOSS alternative to this for non-commercial projects? I'd like to have a spreadsheet on my site for personal use.

FWIW, I went through a bunch of these libraries recently for a personal-site spreadsheet as a react component. All I wanted was a grid where each cell was a calculation based on the combination of its row/column header values. I kept running into the problem where the data grid library gave me 90% of what I needed, a different 90% each time. What actually ended up working perfectly for me was react-table and just using hooks to do the formula calculations.

Re: Show HN: Datagridxl2.js – Fast Excel-like data table library

#42

Post by oneweekwonder »

shafyy wrote: post #35

Looks interesting. I've just been looking at a couple of alternatives to this. We're adding a CSV import feature for our store finder, and the idea is to provide a spreadsheet-like interface where you can just copy and paste your location data instead of uploading a CSV where you need to deal with different delimiters and getting the column orders right etc.

If your up for jQuery-ui see SlickGrid examples[0] especially "Spreadsheet: features of the previous example but using a DataView"[1].

[0]: https://github.com/6pac/SlickGrid/wiki/Examples

[1]: http://6pac.github.io/SlickGrid/examples/example-spreadsheet...

Re: Show HN: Datagridxl2.js – Fast Excel-like data table library

#44

Post by shafyy »

mritchie712 wrote: post #40
shafyy wrote: post #35

Looks interesting. I've just been looking at a couple of alternatives to this. We're adding a CSV import feature for our store finder, and the idea is to provide a spreadsheet-like interface where you can just copy and paste your location data instead of uploading a CSV where you need to deal with different delimiters and getting the column orders right etc.

You might be better off with something like https://csvbox.io/

Interesting, thanks for sharing!

Re: Show HN: Datagridxl2.js – Fast Excel-like data table library

#45

Post by shafyy »

oneweekwonder wrote: post #42
shafyy wrote: post #35

Looks interesting. I've just been looking at a couple of alternatives to this. We're adding a CSV import feature for our store finder, and the idea is to provide a spreadsheet-like interface where you can just copy and paste your location data instead of uploading a CSV where you need to deal with different delimiters and getting the column orders right etc.

If your up for jQuery-ui see SlickGrid examples[0] especially "Spreadsheet: features of the previous example but using a DataView"[1]. [0]: https://github.com/6pac/SlickGrid/wiki/Examples [1]: http://6pac.github.io/SlickGrid/examples/example-spreadsheet...

Cool, thanks for sharing!

Re: Show HN: Datagridxl2.js – Fast Excel-like data table library

#46

Post by jassmith87 »

timkpaine wrote: post #18
anewhnaccount2 wrote: post #10

Earlier quoted context omitted.

Looks quite similar to me. Both are using canvas (combined with off screen rendering?) under the covers which seems to be key to achieving this level of performance.

No reason to sacrifice accessibility and styling in the name of performance: https://github.com/jpmorganchase/regular-table

Glide Data Grid has a fully accessible DOM subtree. No need to sacrifice accessibility just to use a canvas. Come on, its 2022 we have the tools. What makes Canvas even nicer is I can export a subdom that is bespoke for screen readers. It is exactly what the screen readers want, nothing more, nothing less. It works wonderfully.

Disclosure: I am the primary developer of Glide Data Grid.

Re: Show HN: Datagridxl2.js – Fast Excel-like data table library

#47

Post by robbiejs »

wittjeff wrote: post #26

Accessibility is a strong gating factor for some (including me). I don't see it in the docs. The whole thing seems to be missing any ARIA (see https://www.w3.org/TR/wai-aria-practices/examples/grid/dataG... ) Let me know if you want help.

Thanks for your feedback. It's true, I have not made any real efforts when it comes to accessibility (apart from choosing DOM over Canvas). I would very much like to make DataGridXL as accessible as I can, but right now it is not a priority. Thank you very much for sharing the link, that looks really helpful. Are you experienced in making data grids accessible?

Re: Show HN: Datagridxl2.js – Fast Excel-like data table library

#48

Post by TAForObvReasons »

eitland wrote: post #15
bklyn11201 wrote: post #3

The performance here is amazing. Well done! I'm desperately searching for a way to replace old Handsontable (before they closed source), but the license here for DataGrid XL makes it impossible to easily bring into a large FOSS project. Some ideas for licensing: dual license MIT and commercial. Feed advanced features and support into the commercial while keeping the MIT version fast, performant, extendable.

I think it was handsontable I burned myself on: got client to sponsor/pay for support for a nice open source tool and shortly after they went closed source. Same with caddy, except that time it was my money. Some times I wonder if I should avoid giving money to open source projects because it seems to trigger the idea that one can make a whole lot of more money by selling out.

Handsontable made at least $1.5M https://www.indiehackers.com/post/how-to-earn-1-5m-in-revenu... . Whether that's "a whole lot" is questionable.

Re: Show HN: Datagridxl2.js – Fast Excel-like data table library

#49

Post by robbiejs »

whalesalad wrote: post #12

Been using AgGrid but looking for a replacement. I tried to load a CSV of 100k items here and got a "RangeError: Maximum call stack size exceeded." https://www.datagridxl.com/demos/import-csv-data

I haven't tried using DataGridXL with a file with that many records. There is a chance that the DOM node that is used for scroll-listening grows too large and browsers cannot handle that. I suspect that is where the error comes from.

However, I will add this to our list of issues, see where the error really comes from and where I can improve it (https://github.com/DataGridXL/DataGridXL2/issues/31). For now, I would say 10,000 records max to be sure.

Re: Show HN: Datagridxl2.js – Fast Excel-like data table library

#50

Post by robbiejs »

a9h74j wrote: post #5

I'm impressed by the lack of dependencies and single-file download. One of my use-cases is for offline use, and not via a web app installation -- only assets in an ordinary filesystem directory. Mega-components in single js files are a good step towards that.

Thank you. Wanted to keep it simple and lightweight. Not the biggest fan of an average React/Angular project with 200mb+ of dependencies.
Post reply on HN