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

31–40 of 136 posts

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

#32

Post by prionassembly »

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…

Ah, finance.

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

#33

Post by coopsmgoops »

rowsncolumns wrote: post #24

Another plug - https://rowsncolumns.app It's a canvas based SpreadSheet. The Grid works with React and Konva - https://konvajs.org/ You can see the demo here - https://rowsncolumns.app/demo And a whole bunch of features and upcoming roadmap - https://rowsncolumns.app/#features We are launching formula support with Web Workers soon.

Genuinely curious. Why go with canvas over HTMl elements? Isn't it reinventing the wheel a bit for things like input fields

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

#35

Post by rowsncolumns »

coopsmgoops wrote: post #33
rowsncolumns wrote: post #24

Another plug - https://rowsncolumns.app It's a canvas based SpreadSheet. The Grid works with React and Konva - https://konvajs.org/ You can see the demo here - https://rowsncolumns.app/demo And a whole bunch of features and upcoming roadmap - https://rowsncolumns.app/#features We are launching formula support with Web Workers soon.

Genuinely curious. Why go with canvas over HTMl elements? Isn't it reinventing the wheel a bit for things like input fields

Sure. Input elements are still HTML FYI, we dont use canvas to simulate that.

I have been working with DataGrids for more than 4-5 years. So I consider myself at a position to compare HTML and Canvas performance

We went with Canvas because of the following reasons

1. Scroll performance is much better than HTML

2. Drawing on canvas is cheap compared to modifying DOM or attributes

3. Streaming updates are much smoother in canvas as drawing is quick. I had used Canvas as an interface for high-frequency trading

4. Canvas is easy to work with. And with https://konvajs.org/, any React developer will find it at home

5. No more Browser bugs :)

6. Performance tuning is quicker with Canvas

7. In the future, we can decide to use WebGL (using PixiJS)

Some problems with canvas IMO

1. There is no relative positioning :(. It sounds silly, but coming from HTML, any element can be positioned relative to its parent.

2. Styling/Pixel ratio/Stroke - can be hard to figure out first. And the 0.5px crisp stroke workaround on DPR 1 devices. Took me a long time to figure out

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

#36

Post by w-ll »

oh man javascript devs are looking at what winform devs have been getting away with for years...

on top of the unimpressive feature set and price, they really dont have a good remote support... like Im just gonna send a json object with nearly 100 million rows.

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

#37

Post by xyzzy_plugh »

rowsncolumns wrote: post #24

Another plug - https://rowsncolumns.app It's a canvas based SpreadSheet. The Grid works with React and Konva - https://konvajs.org/ You can see the demo here - https://rowsncolumns.app/demo And a whole bunch of features and upcoming roadmap - https://rowsncolumns.app/#features We are launching formula support with Web Workers soon.

On mobile it _looks_ like a spreadsheet but seems entirely unresponsive to, for example, selecting a cell.

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

#39

Post by rowsncolumns »

xyzzy_plugh wrote: post #37
rowsncolumns wrote: post #24

Another plug - https://rowsncolumns.app It's a canvas based SpreadSheet. The Grid works with React and Konva - https://konvajs.org/ You can see the demo here - https://rowsncolumns.app/demo And a whole bunch of features and upcoming roadmap - https://rowsncolumns.app/#features We are launching formula support with Web Workers soon.

On mobile it _looks_ like a spreadsheet but seems entirely unresponsive to, for example, selecting a cell.

Yeah. We may use learnings from Google Sheets on Mobile to design mobile interactions.

Cell Editing will be moved to the bottom

Cell-selection handles will be changed.

Formatting Toolbar will be displayed On-demand

Few more enhancements to make it touch friendly. We didnt receive any requests yet for mobile-support. When we do, it will be in our roadmap

Post reply on HN