111–120 of 136 posts
Nice. I read a CSV file with one mutli-line column in the last field with no problem, but when I copied the data, refreshed the page, and copied to empty grid, now the multi-line field incorrectly was split to the next line.
The features of a commercial grid that I'm currently using: * incremental updates, inserts, deletes * nested grids * formula based coloring of cells * column based filtering
Regarding other bullet points:
* Nested Grids: no * Formulas: no / not anytime soon * Column based filtering: not on top of the list, but definitely doable.
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'm not sure if this is just me, but the demos all fail because they try to load https://code.datagridxl.com/datagridxl.js and it's returning a 404.
Earlier quoted context omitted.
Hi Robert, This looks like a really great (clean and performant) JS library for interacting with data grid. I'll definitely remember to try it for my next side project. A quick question: is there a way to make only some of the columns read-only in the grid? I looked through the doc [ https://www.datagridxl.com/docs/setting-options ] and it seems like user actions for columns are all (applied to every column) or none.…
Hi, Thanks for your feedback! Right now there is no such option, but it's definitely on the todos of 2020. At this moment there are not many individual column options: the goal is to implement validation, formatting, read-only prop, etc. At this moment every column just displays raw values & everything's editable.
Earlier quoted context omitted.
jexcel is great, it has more features (sorting, formulas, colors, etc)... but those same features are not very performant with many (>1000) rows since each cell is a html table cell. datagridxl looks promising if you need to display lots of data. I'm a fan of any open source data grid library so I'm happy both exists.
What I appreciate about Jexcel is their numerous input methods (like dropdowns and checkboxes). DGXL does not offer these features at this moment. Both Jexcel and Handsontable are quite excellent when it comes to the amount of features, but they do have the same downsides: their enthusiastic creators implement any feature that they can dream off, ingoring the effects on performance and a growing code base that gets m…
How does that compare to https://github.com/paulhodel/jexcel ?
jexcel is great, it has more features (sorting, formulas, colors, etc)... but those same features are not very performant with many (>1000) rows since each cell is a html table cell. datagridxl looks promising if you need to display lots of data. I'm a fan of any open source data grid library so I'm happy both exists.
The features of a commercial grid that I'm currently using: * incremental updates, inserts, deletes * nested grids * formula based coloring of cells * column based filtering
Hi. Can you explain what you mean by "incremental updates"? Regarding other bullet points: * Nested Grids: no * Formulas: no / not anytime soon * Column based filtering: not on top of the list, but definitely doable.
Earlier quoted context omitted.
Hi, Thanks for your feedback! Right now there is no such option, but it's definitely on the todos of 2020. At this moment there are not many individual column options: the goal is to implement validation, formatting, read-only prop, etc. At this moment every column just displays raw values & everything's editable.
Thank you for the reply, Robert! I have bookmarked the site and will be recommending my friends to try out Datagridxl.js in their projects. :)
Earlier quoted context omitted.
What I appreciate about Jexcel is their numerous input methods (like dropdowns and checkboxes). DGXL does not offer these features at this moment. Both Jexcel and Handsontable are quite excellent when it comes to the amount of features, but they do have the same downsides: their enthusiastic creators implement any feature that they can dream off, ingoring the effects on performance and a growing code base that gets m…
https://www.youtube.com/watch?v=vV6t1nv2Fjc
Earlier quoted context omitted.
Hi. Can you explain what you mean by "incremental updates"? Regarding other bullet points: * Nested Grids: no * Formulas: no / not anytime soon * Column based filtering: not on top of the list, but definitely doable.
Hi, for an example, check out how the devxtreme datagrid uses a datasource object to manipulate the data in the grid in real time. Which means, instead of loading all the data into the grid before it is rendered at the time of declaration, the data can be appended, updated or deleted as it streams from a backend.