Excel4Node: How to download an excel file without saving?

Question

Using excel4node I am able to write the file to the harddrive. But rather I would like to return it as a download without saving the file on the server. I think the following code is required, but unsure how to use it:

wb.writeToBuffer().then(function(buffer) {
  console.log(buffer);
});

Does anyone have an idea on this?

unfortunately I haven't. As I was unable to get it to work, I left the feature from my project for the moment and focussed on other more important things. I havent tried @Shubh Patels suggestion yet though — xfscrypt, Feb 12 '20 at 09:49

score 5 · Answer 1 · answered Dec 04 '19 at 19:44

Here is an example with nodeJS/Express GET Request. Is this what you're looking for ?

var xl = require('excel4node');

router.route("/test/").get((req, res) => {
    var wb = new xl.Workbook();
    var ws = wb.addWorksheet('SHEET_NAME');
    ws.cell(1, 1).string('ALL YOUR EXCEL SHEET FILE CONTENT');
    wb.write(`FileName.xlsx`, res);

});

score 2 · Answer 2 · answered May 01 '19 at 12:05

2

let binarybuffer = new Buffer(buffer, 'binary');
res.attachment('filename.xlsx'); 
return res.send(binarybuffer);

answered May 01 '19 at 12:05

viveksharma

557
4
9

score 0 · Answer 3 · answered Mar 11 '21 at 10:30

//front-end react --

var fileDownload = require('js-file-download');  //npm i js-file-download
    axios({
        url:url,
        method: 'GET',
        responseType: 'blob', // Important
    }).then((response) => {
        fileDownload(response.data, `FileName.xlsx`);
    });

Excel4Node: How to download an excel file without saving?

3 Answers3

Linked