javascript - Export array of JSON objects to Excel using SheetJS - Stack Overflow

admin管理员组

文章数量:1344297

I have an array of JSON objects, like this:

[
  {"name":"John", "city": "Seattle"},
  {"name":"Mike", "city": "Los Angeles"},
  {"name":"Zach", "city": "New York"}
]

when I use the code below, it's not working:

     _export: function(records,opts) {
                    var XLSX = xlsx;
                    var fileName = opts.split(".")[2]
                    var workSheet = XLSX.utils.json_to_sheet(records);
                    console.log("THis is Worksheet",workSheet);
                    var wb = XLSX.utils.book_new();
                    console.log("THis is workbook",wb)
                    XLSX.utils.book_append_sheet(wb, workSheet, fileName);
                    
                    var bin = XLSX.write(wb, {bookType:'xlsx',type: "binary"});
                    return new Blob([this._binStr2ArrBuff(bin)], { type: "" });
                },
            },

I'm using SheetJS version 0.9.11, just wanted to check if there is any way to export it into Excel format? I'm stuck here for the last 2 days. Any help would be highly appreciated.

I have an array of JSON objects, like this:

[
  {"name":"John", "city": "Seattle"},
  {"name":"Mike", "city": "Los Angeles"},
  {"name":"Zach", "city": "New York"}
]

when I use the code below, it's not working:

     _export: function(records,opts) {
                    var XLSX = xlsx;
                    var fileName = opts.split(".")[2]
                    var workSheet = XLSX.utils.json_to_sheet(records);
                    console.log("THis is Worksheet",workSheet);
                    var wb = XLSX.utils.book_new();
                    console.log("THis is workbook",wb)
                    XLSX.utils.book_append_sheet(wb, workSheet, fileName);
                    
                    var bin = XLSX.write(wb, {bookType:'xlsx',type: "binary"});
                    return new Blob([this._binStr2ArrBuff(bin)], { type: "" });
                },
            },

I'm using SheetJS version 0.9.11, just wanted to check if there is any way to export it into Excel format? I'm stuck here for the last 2 days. Any help would be highly appreciated.

• javascript
• excel
• vue.js
• sheetjs

Share Improve this question Follow edited Mar 16, 2021 at 6:59 Max 1,06011 gold badge1212 silver badges2020 bronze badges asked Aug 24, 2018 at 10:51 MavericksMavericks 28311 gold badge77 silver badges2020 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 7

I think you have to use XLSX.writeFile(wb, 'book.xlsx') for export Excel file.

Replace this code:

var bin = XLSX.write(wb, {bookType:'xlsx',type: "binary"});
return new Blob([this._binStr2ArrBuff(bin)], { type: "" });

Here is the reference:https://lovemewithoutall.github.io/it/json-to-excel/

本文标签： javascriptExport array of JSON objects to Excel using SheetJSStack Overflow