simple-xls

1.0.0 • Public • Published

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);

Readme

Keywords

none

Package Sidebar

Install

npm i simple-xls

Weekly Downloads

1

Version

1.0.0

License

MIT

Last publish

Collaborators

  • marseille