Export to excel with React and SheetJS

javascript reactjs spreadsheet export-to-excel sheetjs
Palaniichuk Dmytro picture Palaniichuk Dmytro · Feb 5, 2018 · Viewed 7.6k times · Source

I am trying to implement export to excel with React and SheetJs library. Looks like I can download it, but the actual output does not look as expected. I receive array of object and use XLSX.utils.json_to_sheet([data]) API to converts an array of JS objects to a worksheet. Problem is : enter image description here

I've reproduced it here

Answer

Palaniichuk Dmytro picture Palaniichuk Dmytro · Feb 5, 2018

Fixed here enter link description here

Bug was with XLSX.utils.json_to_sheet([data]) XLSX.utils.json_to_sheet(data) this utils use object of array as aurgument instead array of objects

Change wb.SheetNames.push(''); wb.Sheets[''] = ws to wb.SheetNames.push('sheet1'); wb.Sheets['sheet1'] = ws so that you will not get data recovery error while opening file

Related questions

Loop inside React JSX

I'm trying to do something like the following in React JSX (where ObjectRow is a separate component): <tbody> for (var i=0; i < numrows; i++) { <ObjectRow/> } </tbody> I realize and understand why this isn't …

Read More
"SyntaxError: Unexpected token < in JSON at position 0"

In a React app component which handles Facebook-like content feeds, I am running into an error: Feed.js:94 undefined "parsererror" "SyntaxError: Unexpected token < in JSON at position 0 I ran into a similar error which turned out to be a …

Read More
Show or hide element in React

I am messing around with React.js for the first time and cannot find a way to show or hide something on a page via click event. I am not loading any other library to the page, so I am …

Read More