Breaking News: Grepper is joining You.com. Read the official announcement!

express response with xlsx buffer

Ashar Dweedar answered on February 28, 2023 Popularity 1/10 Helpfulness 1/10

answer express response with xlsx buffer

express response with xlsx buffer

Comment

const xlsx = require('xlsx')

var wb = xlsx.utils.book_new();

var table = [['a', 'b', 'c'], ['1', '2', '3']]
var ws = xlsx.utils.aoa_to_sheet(table);
xlsx.utils.book_append_sheet(wb, ws, 'test');

// write options
const wopts = { bookType: 'xlsx', bookSST: false, type: 'base64' };
const buffer = xlsx.write(wb, wopts);

res.writeHead(200, [['Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet']]);
res.end(new Buffer(buffer, 'base64'));

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: stackoverflow.com

Tags: buffer express javascript response xlsx

Link to this answer
Share Copy Link