CODEWITHSUNDEEP
javascriptreactjsspreadsheetexport-to-excelsheetjs
Palaniichuk Dmytro
Palaniichuk Dmytro

Reputation: 3173

Export to excel with React and SheetJS

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

Upvotes: 8

Views: 12734

Answers (1)

Palaniichuk Dmytro
Palaniichuk Dmytro

Reputation: 3173

Fixed here: https://stackblitz.com/edit/react-yg6pt5?file=exportToExcel.js

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

Upvotes: 6

Related Questions