导出前端的table为excel，兼容IE

最新推荐文章于 2020-08-20 16:17:42 发布

社会你鬼哥

最新推荐文章于 2020-08-20 16:17:42 发布

阅读量342

点赞数

分类专栏：前端

本文链接：https://blog.csdn.net/u012612062/article/details/106563697

版权

前端专栏收录该内容

2 篇文章 0 订阅

订阅专栏

//base64转码
var base64 = function (s) {
    return window.btoa(unescape(encodeURIComponent(s)));
};
//替换table数据和worksheet名字
var format = function (s, c) {
    return s.replace(/{(\w+)}/g,
        function (m, p) {
            return c[p];
        });
}
function tableToExcel(tableid, sheetName) {
	
    var uri = 'data:application/vnd.ms-excel;base64,';
    var template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel"' +
    'xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet>'
    + '<x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets>'
    + '</x:ExcelWorkbook></xml><![endif]-->' +
    ' <style type="text/css">' +
    'table td {' +
    'border: 1px solid #000000;' +
    'height: 30px;' +
    ' text-align: center;' +
    'color: #000000;' +
    ' }' +
    '</style>' +
    '</head><body ><table class="excelTable">{table}</table></body></html>';
    if (!tableid.nodeType) tableid = document.getElementById(tableid);
    var ctx = { worksheet: sheetName, table: tableid.innerHTML };
    var data = base64(format(template, ctx));
    if (window.navigator.msSaveBlob){
        var blob = b64toBlob(data);
        window.navigator.msSaveBlob(blob, sheetName);
    } else {
        var alink = $('<a style="display:none"></a>').appendTo('body');
        alink[0].href = URL.createObjectURL(b64toBlob(data));
        alink[0].download = sheetName;
        alink[0].click();
        alink.remove();
    }
}
function b64toBlob(data){
    var sliceSize = 512;
    var chars = atob(data);
    var byteArrays = [];
    for(var offset=0; offset<chars.length; offset+=sliceSize){
        var slice = chars.slice(offset, offset+sliceSize);
        var byteNumbers = new Array(slice.length);
        for(var i=0; i<slice.length; i++){
            byteNumbers[i] = slice.charCodeAt(i);
        }
        var byteArray = new Uint8Array(byteNumbers);
        byteArrays.push(byteArray);
    }
    return new Blob(byteArrays, {
        type: ''
    });
}

// 参数一：要导出的table的ID，参数二：导出的excel名称
tableToExcel('tableExcel', name);

社会你鬼哥

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
3
评论
导出前端的table为excel，兼容IE

//base64转码var base64 = function (s) { return window.btoa(unescape(encodeURIComponent(s)));};//替换table数据和worksheet名字var format = function (s, c) { return s.replace(/{(\w+)}/g, function (m, p) { return c[p]; });}fun.
复制链接

扫一扫