xlsx-writer-stream

A xlsx writer by stream in Node.js

Usage no npm install needed!

<script type="module">
  import xlsxWriterStream from 'https://cdn.skypack.dev/xlsx-writer-stream';
</script>

README

xlsx-writer-stream

A xlsx writer by stream in Node.js

Installation

$ npm install xlsx-writer-stream

Example

var XLSXWriterStream = require('xlsx-wirter-stream');

var writer = new XLSXWriterStream({
    file: 'example.xlsx'
});

// Optional: Adjust column widths
writer.defineColumns([
    { width: 20 },
    { width: 10 }
]);

// Optional: Set cell map title
writer.setCellMap(['name', 'value']);

// Add some simple rows
writer.addRow(['pauky', 'ykk']);
writer.addRow(['glowry', 'yrw', 'test']);

// Add multiple rows
writer.addRows([['1', '2'],['a', 'b']]);

// Finalize the spreadsheet. If you don't do this, the readstream will not end.
writer.finalize();

License

MIT