Reputation: 108
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
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