SheetJS js-xlsx VS React Data Grid

ExcelJS and XLSX (SheetJS) are great libraries to work with XLSX files. The former I've found a bit easier to work with but less efficient in general.

Sure. I manipulate excel files programatically in the browser all the time. I don't really understand your exact workflow, but I use Javascript with xlsx and React.

Looking at the xlsx documentation, to parse files in the browser, rather than readFile, you use read, which is designed to parse binary data directly, rather than read from disk. There are a bunch of different formats if you go to the XLSX NPM page and scroll down to "Acquiring and Extracting Data". Importantly, it seems the data must already be serialized, so a Blob won't work, but we can work with that.

Last year, Bing and Edge erroneously flagged our website https://sheetjs.com/ as "dangerous": https://i.imgur.com/BvA3zrk.png

At the time, there was no "Safety Report" to indicate why Bing thought it was dangerous. The report page linked to https://www.bing.com/toolbox/bing-site-safety?url=https%3a%2... and it said "That web page doesn't exist"

To fix it, we had to register with "Bing Webmaster Tools" (https://www.bing.com/webmasters/about) and raise a support ticket.

Within a few days, the issue "resolved itself". It's possible that raising a ticket forced some automatic refresh of the indexed data for the domain.

xlsx.

SheetJS | https://sheetjs.com/ | Software Developer | Full time, Remote (US) | $165K - $240K

We're a bootstrapped company building open source solutions for spreadsheets and structured data. With over 1.5M unique monthly visitors, companies across the business world turn to us for challenging data processing problems. Over the last 10 years, we have pushed the boundaries of JavaScript and the web.

In this role, you will master new and established technologies while working on high-impact projects used by millions of people across the world. Balancing research and engineering, you will design and implement creative solutions that draw from your academic and professional experience.

https://sheetjs.com/careers/ more details

For more, you can visit xlsx documentation Link.

There are libraries like https://github.com/SheetJS/sheetjs to parse excel and https://www.chartjs.org/ for all kinds of charts/graphs. Not really much HTML involved here.. the markup gets generated by the chart library.

It’s called a DataGrid. I would not implement my own. https://github.com/adazzle/react-data-grid

Data Grid - https://github.com/adazzle/react-data-grid

Do you mean grid like CSS grids https://developer.mozilla.org/en-US/docs/Web/CSS/CSS_Grid_Layout or do you mean grid like data grid https://www.npmjs.com/package/react-data-grid ? Because I think people are assuming in their answers you mean the former. If its the second one its a whole other discussion.

I am using react-data-grid component. It provides a grid structure with edit and lot more options. When we click on each cell, we are able to edit the content of the cell. In my project, I have a situation like when the date column is focused I want to bind a UI where the user can able to select the date.for that, I have used react-datepicker component. I am able to give react-datepicker component as a formatter in the date column option. I can able to change the date in the react datepicker component, but that is not updating the cell value (when you click on the console data button you can able to see the changes have been updated or not).so guys help me how I can update the cell value when a different date is selected in the react-datepicker component. It happening automatically when the value is changed in other cells.

no, i missed that one when i was searching, but from the homepage and a quick glance through the docs it doesn't seem like it does what i need. what i want is something like react-data-grid [https://github.com/adazzle/react-data-grid] but with a backend component that handles collaborative updates. essentially a stripped down and actively maintained alternative to ethercalc [https://ethercalc.net/]

baserow had a lot of what i wanted, but the top-level feature set seemed very oriented towards a db admin tool rather than a programmatically managed user interface to single tables or views.

I have a bulk of tabular data that I'd like for my users to be able to manipulate with a lot of the kind of standard spreadsheet functions like filter, sort, search. Generally I'm more interested in read than write. I can across: https://github.com/adazzle/react-data-grid

I has dnd grouping, but it falls short on server side rendering. It seems like the maintainers are not interested in implement this feature(https://github.com/adazzle/react-data-grid/pull/1459)

I'm trying to add excel like filtering to react-data-grid with primereact multiselect and running into some problems with the dropdown closing. By excel like filtering I mean when you apply a filter that updates all the other filters options instead of keeping the total options always. Here is a codesandbox that show the problem. So basically I want the dropdown to stay open even when the dropdown options change. Also you would notice this kind of makes a multiselect useless since the current filter your on will always be filter down to 1 option. So the current filter being changed should not change options but all the others filter options should change.