node js create excel file with xlsx

node js create excel file with xlsx

> npm xlsx i

ref>> 

• https://github.com/SheetJS/sheetjs/tree/master/demos/server
• https://sheetjs.com/demo/manifest.html
• https://github.com/SheetJS/sheetjs#utility-functions
• https://github.com/SheetJS/sheetjs#writing-options

        var fileName = "555.xlsx"

        var datas = [[1, 2, 3], [true, false, null, "sheetjs"], ["foo", "bar", new Date("2014-02-19T14:30Z"), "0.3"], ["baz", null, "qux"]]

        var wsName = "SheetJS"

        // console.log(data)

        /* generate workbook */

        var ws = XLSX.utils.aoa_to_sheet(datas);

        var wb = XLSX.utils.book_new();

        XLSX.utils.book_append_sheet(wb, ws, wsName)

        /* generate buffer */

        var buf = XLSX.write(wb, { type: 'buffer', bookType: "xlsx" })

        /* send to client */

        res.attachment(fileName)        //set filename

        res.status(200).send(buf)