nodejs导出csv文件


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);
};

 


版权声明:本文为qq_39634880原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。