CODEWITHSUNDEEP
node.jsxlsxsheetjs
user433342
user433342

Reputation: 1050

Stream SheetJS xlsx to form-data in node

I need to generate and upload a xlsx in node. Any way to do this without saving the file to disk?

import FormData from 'form-data';
import XLSX from 'xlsx';
import * as fs from 'fs';

var form = new FormData();
var data = [['a','b'],[1,2]];
var ws = XLSX.utils.aoa_to_sheet(data);
let wb = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(wb, ws, "Sheet1");

//can I combine the next 2 lines somehow?
XLSX.writeFile(wb, 'abc.xlsx', {compression:true});
form.append('file', fs.createReadStream('abc.xlsx'));
//...

Upvotes: 1

Views: 38

Answers (1)

traynor
traynor

Reputation: 8717

Just write the workbook as a buffer (by passing buffer type to write, see write output types), and then simply append it to form-data:

const file = XLSX.write(wb, {type: 'buffer', compression:true});

form.append('file', file, {filename: 'abc.xlsx'});

Upvotes: 0

Related Questions