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.
I maintain https://grid.glideapps.com if you're looking for something ludicrously fast.
Show HN: Datagridxl2.js – Fast Excel-like data table library
51–60 of 108 posts
Re: Show HN: Datagridxl2.js – Fast Excel-like data table library
#52Hey Robbert, just want to say congrats on this! This is excellent work and really thoughtful / detailed. I'll definitely be using on a project soon. Really love the elegant docs and the API.
Thank you! Appreciate it very much! Let me know what you're working on when you get to it! robbert at datagridxl.com
Re: Show HN: Datagridxl2.js – Fast Excel-like data table library
#53Re: Show HN: Datagridxl2.js – Fast Excel-like data table library
#54This caught my eye. We are in the market for a high-quality gridview component that would allow for in-line edits. We also looked at CSV in/out, but having something integrated could be better. The UX would have to be on-par with excel and this seems close. My biggest question right now: What does integration of Datagridxl2 look like when operating with a Blazor Server app? Should I just expect some basic JS interop…
I do not know anything about Blazor Server app or how it works. DataGridXL is all about client-side interaction: mouse events, touch events, keyboard events etc, as such it cannot function on a server alone, if that is what you mean.
Re: Show HN: Datagridxl2.js – Fast Excel-like data table library
#55Been 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…
There is a million record demo? That is where my confusion comes from.
Re: Show HN: Datagridxl2.js – Fast Excel-like data table library
#56How does it compare with https://grid.glideapps.com/ ?
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.
DataGridXL actually only uses canvas for cell background colors (when you use the search bar) and for measuring text width. Everything else is DOM, just not with individual cells.
Re: Show HN: Datagridxl2.js – Fast Excel-like data table library
#57Wonderful work! If you think your table is the best, as someone who is pondering buying it, you'd save me some time if you had a quick comparison matrix with your main competitors. It seems counterintuitive to provide that but most people will do the research anyway so you're just saving them some time searching and cataloguing alternatives.
Thank you. I did have an article on the site that compared DataGridXL with Handsontable, but we had to take it offline since HoT lawyers were not happy with it (you can read a discussion about that here: https://news.ycombinator.com/item?id=30503983). Anyway, it's a good idea. I will create one with Handsontable, Ag-grid, anything else?
Re: Show HN: Datagridxl2.js – Fast Excel-like data table library
#58Very nice! Just, I'm not sure that users who stick to Excel despite a web app do so just because of Excel's interface... sometimes it is because it is much easier to work with files than with web sites. And sometimes the way to get to the web app is the thing destroying the UX (slowly responding servers, weird login processes, etc.)
Ah yes I see what you mean.
I used to work for a fintech startup and our sales team had a hard time finding customers for the product that we're building. These customers were impressed by the web app that we've made, but "we don't see a reason to use your products, we are used to Excel and we like Excel". So we decided to create a page in our web app that looked like Excel. I initially used Handsontable for this page. I was so disappointed with its performance and its reliability, that I decided to create DataGridXL. Anyway, that's the story and that's where the "slogan" comes from :-)
Re: Show HN: Datagridxl2.js – Fast Excel-like data table library
#59One feedback, undo is currently slow even if I just want to undo 5 cells of data.
Can you tell me what webpage you're on (and your device+browser). Undoing should happen instantly.
Re: Show HN: Datagridxl2.js – Fast Excel-like data table library
#60Accessibility 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?
I've done a lot of work on data grid accessibility. In fact, DataGridXL is one of the many grids I considered for our own needs a couple years ago. The reality here is unless you somehow export out a DOM structure which has an element per cell, for at least the cells that are on screen, you will never be able to get the screen reader to behave correctly. If you were using a canvas you could export a subdom on the canvas, but with the approach y'all take with the line-height + dom node per column I don't see how you get there.
The cell nodes need be browsable and selectable by the screen readers caret. You could do what many other DOM based grids do and add an "accessibility mode" but I believe accessibility should be the default and not a mode people turn on as a checkbox. Let me know if you want to chat, I'm always happy to share what I know. I'm by no means an expert but I've definitely picked up a thing or two.