1、前端AngularJs
$scope.Export=function(person,date){
$http.get("http://127.0.0.1:8080/backExport", {
params: {"testData":testData},
responseType: 'arraybuffer' //此处必须添加responseType类型
}).success(function (data) {
var blob = new Blob([data], {type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"});
var objectUrl = URL.createObjectURL(blob);
var a = document.createElement('a');
document.body.appendChild(a);
a.setAttribute('style', 'display:none');
a.setAttribute('href', objectUrl);
a.setAttribute('download', "Backstore.xlsx");
a.click();
URL.revokeObjectURL(objectUrl);
});
}
2、后端node.js借助模块ejsExcel,准备好模板Excel文档
后端代码
var express=require('express');
var app=express();
app.use(express.static('public'));
app.use(bodyParser.urlencoded({ extended: false }));
var ejsExcel = require("ejsExcel");
var fs = require('fs');
app.get('/backExport',function(req,res){
var exlBuf = fs.readFileSync("export/backExcel.xlsx");//模板文件
var rs1= exportdata;//待写入数据
ejsExcel.renderExcelCb(exlBuf, rs1, function(err,exlBuf2){
if(err) {
console.error(err);
return;
}
res.setHeader('Content-Type', 'application/vnd.openxmlformats');
res.setHeader("Content-Disposition", "attachment; filename=" + "Backstore.xlsx");
res.end(exlBuf2, 'binary');
console.log('export successfully!');
});
})