Live data from Hacker News

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

datagridxl.com

71–80 of 108 posts

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

#71

Earlier quoted context omitted.

Lighthouse [1][2] Accessibility audit/ scores can be a good tool to check A11Y issues automatically, and it is fairly easy to integrate into your CI/CD Pipelines to get the report automatically to check for issues/ regression. The web accessibility world is complex enough that simulating different methods of access like using screen readers or different font-sizes and doing manual tests for compliance is not particul…

I disagree. Automated results are not perfect and miss a lot of nuances, like element ordering, tab indexing, etc. Assuming you can’t find someone experienced with a screen reader to test I would invest in learning how to use one yourself. I’ve spent days without access to my screen in order to grow more comfortable navigating with audio. Of course, I won’t be as helpful or quick as someone who’s used a screen reader…

> but it’s better than blindly trusting lighthouse/web.dev

Interesting use of "blindly". Using lighthouse or other accessibility checkers is better than not considering accessibility at all, and has a much lower barrier for developers and development orgs than integrating screen readers into the development lifecycle.

I was in an org where our QA team actually used our sites with screen readers, and yet we still ran automated accessibility tests on our codebase. This is because we can catch issues earlier and more easily, and reduce the amount of issues making it to manual QA which is much more time consuming and expensive.

Manual QA testers using screenreaders are also not perfect and miss a lot of nuances :)

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

#72

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

You might enjoy this site: https://jsgrids.statico.io/

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

#74
post #16

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

What is motivating you to look for a replacement? We are evaluating grids and AgGrid is the front runner currently though really rather heavyweight for our use cases.

All things considered it’s great software but yes it can be kinda heavyweight at times.

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

#76
post #16

Earlier quoted context omitted.

What is motivating you to look for a replacement? We are evaluating grids and AgGrid is the front runner currently though really rather heavyweight for our use cases.

All things considered it’s great software but yes it can be kinda heavyweight at times.

Would you mind taking a look at grid.glideapps.com and letting me know if/where it doesn't work for you? We are always looking for feedback. Development is done entirely in the open, feel free to just file issues and open discussions on github.

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

#77

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

"Maximum call stack size exceeded" is probably a general bug, not an issue that appears due to trying to load too many rows. Unless they really did something crazy, each new row shouldn't add to the call stack.

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

#78

Earlier quoted context omitted.

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 can…

Seems pretty much impossible to not have an accessibility mode yet have features such as fixed columns/rows. It would be very difficult to have a clean DOM structure while supporting that layout. If it is possible I'd be very interested in how that is done.

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

#79

-"You've built a web app, but your users stick to Excel" I feel that if your users are not using your web app, it's not because they miss the (dated, not exactly intuitive) Excel interface. Seems to me like the wrong solution for the problem

I miss many things about the Excel interface in early every web app:

- editing many records as a table

- formulae for calculating values

- ability to paste from other tables or Excel sheets

- information density!

- arbitrary sort and filter

- hiding and rearranging columns

- etc…

Every app with search, including search engines themselves, and most with data entry should have an Excel-like, table based interface. GitHub discovered this (just look at their new projects) and most data focused apps are no exception either. Terminal utilities, Python scripting, and JSON are sometimes as good or better, but more often a poor second place.

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

#80

Earlier quoted context omitted.

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 can…

Seems pretty much impossible to not have an accessibility mode yet have features such as fixed columns/rows. It would be very difficult to have a clean DOM structure while supporting that layout. If it is possible I'd be very interested in how that is done.

It can be done if you are using a Canvas to provide the rendering. The canvas can then be provided with a subdom that does not render but is visible/interactive to screen readers which matches exactly what the screen reader requires. Canvas's actually have the advantage here if they put the effort into being accessible.

You could do the same trick by hiding the visible DOM from the screen reader and creating an invisible DOM explicitly for the screen reader. If your DOM structure is wrong for the screen reader I would suggest doing this.

Post reply on HN