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

Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

datagridxl.com

Post reply on HN
Print view View original

91–100 of 136 posts

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#91

Post by dkersten »

robbiejs wrote: post #87
dkersten wrote: post #85

Earlier quoted context omitted.

Handsontable has a lot more features, though. Maybe your unique selling points are enough, I don’t know, just on paper handsontable appears to provide a lot more for the price. I’m not suggesting you change it, just something to be aware of for your marketing. For me, personally, handsontable was too expensive too though (I’m just one guy self funding my project) so ended up going with an open source table component…

It all depends on what somebody is looking for: a sortable data table for presentation, a table (structure) editor, a spreadsheet, a data grid? All these things look very similar, but they require different approaches really. You'll always lose on one of the other. Ag-Grid and DataTables are perfect for presentation, not so much for Excel-like editing. Handsontable & Jexcel try to implement all features of Excel, at…

> You'll always lose on one of the other.

Absolutely agree and the open source alternatives tend to do one or two things only (while HoT, DGXL etc seem to offer a lot more in a single package), so for me, it came down to deciding what exactly do I need and if I need something else, maybe I need to use a different one for that.

> I have to make sure that in my marketing

I don't think you need to do too much over what you already have. Maybe put a bit more emphasis on why the "Reliable" part matters. The little blurb on your page about not messing up the DOM isn't really selling it to me, I just looked at it and thought "yeah ok whatever", but this and performance seem to be two of your main distinguishing factors, so I'd lean on them more. Focus on what makes DGXL special. That's just me though.

> Anyway, you're always welcome to use the free version.

I may give it a try. For my main use case, I think the branding is a bit too in-your-face (it would look out of place inside the rest of my web app -- maybe you can provide multiple styles to pick from, just thinking out loud), but overall it looks great so its definitely getting bookmarked.

In any case, great work!

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#92

Post by dkersten »

robbiejs wrote: post #86
dkersten wrote: post #83

Earlier quoted context omitted.

For me, DGXL on iOS lets me select and scroll beautifully, but I cannot actually edit (I guess because the cells aren’t text fields, the device doesn’t know to open the on screen keyboard). So it works very well for output but doesn’t work for input.

You're right, the editor does not open on touch screens in this version. It's still possible to enable editing on touch screen, but it asks for a custom element on the page that interacts with the grid, using methods setCellValues & getCellValues. It's certainly possible. Will put up a demo for it when I find the time.

I just saw you actually do say its readonly in your documentation: https://www.datagridxl.com/docs/touchscreen-support

That solution would actually work perfectly well for me: tap a cell and an edit widget pops up.

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#93

Post by robbiejs »

jbverschoor wrote: post #89
robbiejs wrote: post #74

Earlier quoted context omitted.

Thanks! What features would you like to see implemented?

Probably a plugin system for datatype => renders/editors. ex: (numbers, datepickers, select, checkboxes, etc.)

Ah, that's something I would very much like to implement. Probably only in '21... More pressing stuff first.

Until then, have a look at Jexcel, it implements numerous pickers/editors (not all of them mobile-friendly I believe).

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#94

Post by robbiejs »

dkersten wrote: post #91
robbiejs wrote: post #87

Earlier quoted context omitted.

It all depends on what somebody is looking for: a sortable data table for presentation, a table (structure) editor, a spreadsheet, a data grid? All these things look very similar, but they require different approaches really. You'll always lose on one of the other. Ag-Grid and DataTables are perfect for presentation, not so much for Excel-like editing. Handsontable & Jexcel try to implement all features of Excel, at…

> You'll always lose on one of the other. Absolutely agree and the open source alternatives tend to do one or two things only (while HoT, DGXL etc seem to offer a lot more in a single package), so for me, it came down to deciding what exactly do I need and if I need something else, maybe I need to use a different one for that. > I have to make sure that in my marketing I don't think you need to do too much over what…

Thanks for your feedback, really appreciate it! I think you're right that the "Reliable" feature might not tell the user much.

Perhaps I need to show GIFs of other products to show the numerous ways these products get messy. Anyway, just an idea. Will think about it more, very good point.

You're allowed to adjust the color & type of the branding link, as long as it remains visible :-)

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#95

Post by robbiejs »

pictur wrote: post #90
robbiejs wrote: post #81

Earlier quoted context omitted.

I guess I'll just have to see what happens, who buys it and who does not, and tweak along the way :-)

achievements. please share the developments. your job deserves this money :)

Thanks pictur, appreciate your reply! How would I share the developments? I am not really a Twitter user. (You can however subscribe to a mailing list, which you'll find on the bottom of the homepage.)

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#96

Post by janci »

robbiejs wrote: post #47
sgarrity wrote: post #20

Earlier quoted context omitted.

How did you implement the scrolling such that it feels smooth/fast/native, but scrolls in one row/column steps (so you never see half a row)? CSS Scroll Snap? Nicely done.

Thanks! I'd to write a proper "How It's Made" article about it in the future, but this is basically how it's done: There is a blank DOM node "scrollArea" in front of all others that catches the native JS scroll event. It then converts these scroll offsets (scrollTop and scrollLeft) to cell/viewport coordinates, by default 40px actual pixels per row/column. So if the scrollArea has a scrollLeft of 40px and a scrollTop…

There is a bug that is caused directly by this whitespace hack. If you copy two lines of text and paste it to one cell, it displays as two cells and shifts the column content below the affected cell (if the affected cell is in the viewport)

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#99

Post by infinite8s »

robbiejs wrote: post #53
pugio wrote: post #17

Earlier quoted context omitted.

I have been looking for years for something to replace a custom rendered excel-like table I have. The table has a complex layout: - One fixed top row (date), two or three fixed columns on the left. - Data are rendered horizontally; the number of rows does not change, but the number of columns can be in the hundreds. Does your library support column-oriented data like this (you mention "60+" columns)? Does anyone know…

Hi, The component actually did have fixed/frozen columns/rows in an earlier version, but I decided to leave out the feature for a v1. I plan to reintroduce it after more popular features have been implemented. DGXL is able to handle hundreds of columns. The reason why it says 60+ specifically is that, according to browser-vendors like Mozilla, a DOM node should ideally not have more than 60 child nodes - for performa…

Are columns virtualized as well? That could get over the child node restrictions for performance.

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#100

Post by infinite8s »

pugio wrote: post #17
robbiejs wrote: post #2

Hello HN, I’m Robbert, the creator of DataGridXL.js. 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 (~200kb) and easy to use. It does not even require messing with CSS. - It has its own Virtua…

I have been looking for years for something to replace a custom rendered excel-like table I have. The table has a complex layout: - One fixed top row (date), two or three fixed columns on the left. - Data are rendered horizontally; the number of rows does not change, but the number of columns can be in the hundreds. Does your library support column-oriented data like this (you mention "60+" columns)? Does anyone know…

JPMorgan has open-sourced a DOM based table that might work for you: https://github.com/jpmorganchase/regular-table.

Here's their excel like example showing 200 columns: https://bl.ocks.org/texodus/3e0e3d6f8bf8b47294a7847b402b55fb

Post reply on HN