Ranoy
Ranoy

Reputation: 108

JSON to xls in javascript

Hi I am looking for a way to export JSON data to XLS file.I need to support IE9. I found the js-xlsx library, but it exports in xlsx format.Is there anyother way to export , I need to support multiple worksheets also. Thanks

Upvotes: 1

Views: 2835

Answers (1)

Luca
Luca

Reputation: 1826

Try it with json2xls like this:

var json2xls = require('json2xls');
var json = {
    foo: 'bar',
    qux: 'moo',
    poo: 123,
    stux: new Date()
}

var xls = json2xls(json);

fs.writeFileSync('data.xlsx', xls, 'binary');

https://www.npmjs.com/package/json2xls

Upvotes: 1

Related Questions