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

Show HN: React-data sheet, Excel-like spreadsheet component

nadbm.github.io

Post reply on HN
Print view View original

11–20 of 93 posts

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#11

Post by uptown »

This looks really great, and I've got an immediate use for something like this. I've been using ag-grid for presentation of grid-based data, but this looks ideal for more-interactive views. I look forward to putting it through its paces.

Somewhat off-topic, but for those working in React, have you built large systems using Redux? I'm fairly early in what is likely to ultimately be a large-ish application, and while I've got Redux working, I feel working with it is definitely adding cognitive load to each feature I implement. Just wondering whether it's worth the effort and would appreciate feedback from those who may have more experience weighing the pros and cons of using Redux with their application.

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#12

Post by hive_mind »

euroclydon wrote: post #2

Looks beautiful!! But, I can just imagine running this one by the patent attorneys as an open source library to include in our product.

Why the downvotes? This person is describing a real problem with dealing with staff patent attorneys. This is real life.

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#14

Post by Etheryte »

uptown wrote: post #11

This looks really great, and I've got an immediate use for something like this. I've been using ag-grid for presentation of grid-based data, but this looks ideal for more-interactive views. I look forward to putting it through its paces. Somewhat off-topic, but for those working in React, have you built large systems using Redux? I'm fairly early in what is likely to ultimately be a large-ish application, and while I…

It's important to remember that not all of your state needs to be in Redux. Redux is supposed to supplement local state, not replace it.

Create namespaces in your store, it helps a ton with maintainability in the long run. Name your mutations consistently: describe what you're doing to what kind of data as briefly as you can.

Keeping these few guidelines in mind, building huge applications using any flux-like pattern is quite straight-forward and easy to reason about.

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#16

Post by nadimisl »

hultner wrote: post #15

Any data on how this performs on large datasets? I've previously found that most web based data grids get extremely slow on larger data sets in BI applications (100k+ rows)

Definitely not meant for large datasets. I've tried it with about 100rows and pagination. I would work with react-virtualized for datasets that large

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#17

Post by lpa22 »

uptown wrote: post #11

This looks really great, and I've got an immediate use for something like this. I've been using ag-grid for presentation of grid-based data, but this looks ideal for more-interactive views. I look forward to putting it through its paces. Somewhat off-topic, but for those working in React, have you built large systems using Redux? I'm fairly early in what is likely to ultimately be a large-ish application, and while I…

I have made several relatively large systems using Redux, and it has become a necessity in order to handle complexity of new features. Overcoming the initial cognitive load takes a week or two, but as your system grows, your productivity and code organization is greatly improved. I also recommend Immutable for handling the state object and reselect for computing your container state properties. Those technologies together are a pleasure to develop with.

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#18

Post by misiti3780 »

I am working with two separate clients that need excel spreadsheet functionality in a browser. I evaluated all of the existing open source projects (this wasnt available at the time) and ended up going with fix-data-table-2 (fork of facebooks fix-data-table).

fix-data-table is performant and easily extendable. I was able to create an editable grid similar to googlesheets in a months worth of work. working on open sourcing it soon.

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#19

Post by [deleted] »

misiti3780 wrote: post #18

I am working with two separate clients that need excel spreadsheet functionality in a browser. I evaluated all of the existing open source projects (this wasnt available at the time) and ended up going with fix-data-table-2 (fork of facebooks fix-data-table). fix-data-table is performant and easily extendable. I was able to create an editable grid similar to googlesheets in a months worth of work. working on open sou…

[deleted]

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#20

Post by clishem »

fiatjaf wrote: post #13

This covers 80% of Excel uses, but the rest 20% would take 1000% of the time to implement.

Just some basic functionality that is used when making nearly all spreadsheets: dynamically resizing tables, formating cells, setting cell types (currency, floating point, integer, boolean), conditional formatting, cell ranges, SUM, COUNT, IF, AVG, extending cell contents by dragging.

This project is a proof-of-concept. Nothing more than that.

Post reply on HN