simple-xls v1.0.0

SimpleXLS

Simple XLS exporter in NodeJS.

SimpleXLS.write_to_xls = function(columns, datas)

Columns have the structure:

{
  'label': 'my infinitely expressive column name',
    'name':'my_boring_database_semantic_name'
}

Rows (datas) have the structure:

{
  'my_boring_database_semantic_name': 'foo',
    'my_other_semantic_name': 'bar'
}

The return is a WritableStream from the memory-streams npm package:

https://www.npmjs.com/package/memory-streams

Now all you have to do to return this as an attachment in ExpressJS is:

var SimpleXLS = require('SimpleXLS');
var xls_buffer = SimpleXLS.write_to_xls(columns, rows).toBuffer();
resp.setHeader('Content-Type', 'application/vnd.openxmlformats');
resp.setHeader("Content-Disposition", "attachment; filename=" + "example.xls");
resp.setHeader('Content-Length', xls_buffer.length);
resp.end(xls_buffer);