exports.exportExcel=function(req,res) {
var fileName = "test.xls";
res.set({
'Content-Type': 'application/vnd.ms-execl',
'Content-Disposition': "attachment;filename=" + encodeURIComponent(fileName),
'Pragma': 'no-cache',
'Expires': 0
});
var arr = [{name: '张三', age: '32岁'}, {name: '李四', age: '60岁'}, {name: '王五', age: '10岁'}, {name: '赵六', age: '100岁'}];
var content = '';
content += "名称";
content += '\t';
content += "年龄";
content += '\t';
content += '\t\n';
for (var i = 0, len = arr.length; i < len; i++) {
content += arr[i]['name'];
content += '\t';
content += arr[i]['age'];
content += '\t';
content += '\t\n';
}
var buffer = new Buffer(content);
//需要转换字符集
var iconv = require('iconv-lite');
var str = iconv.encode(buffer, 'gb2312');
res.send(str);
};