使用浏览器生成excel方法及性能测试

1、开发步骤描述：

1.1、前提：需要在web上生成一个table；

g_sTable = '<table display:none id="LogData"><tr><th>'+aHead[0]+'</th><th>'+aHead[1]+'</th><th>'+aHead[2]+'</th></tr>'; var i=0; for(i;i< data.length; i++) { var dataContext = data[i] g_sTable +='<tr><td>'+dataContext.Time+'</td><td>'+dataContext.severityData+'</td><td>'+dataContext.Content+'</td></tr>'; } g_sTable+='</table>'; $("body").append(g_sTable);

1.2、后续操作：
1)谷歌、火狐浏览器；
然后再把该table使用base64编码，URL携带对应文件类型即可；
如：window.location.href = "data:application/vnd.ms-excel;base64,PGh0bWwgeG1sbnM6bz0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6b2ZmaWNlIiB4bWxuczp4PSJ1cm46c2NoZW1hcy1taWNyb3NvZnQtY29tOm9mZmljZTpleGNlbCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnL1RSL1JFQy1odG1sNDAiPjxoZWFkPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPjx4OkV4Y2VsV29ya2Jvb2s+PHg6RXhjZWxXb3Jrc2hlZXRzPjx4OkV4Y2VsV29ya3NoZWV0Pjx4Ok5hbWU+V29ya3NoZWV0PC94Ok5hbWU+PHg6V29ya3NoZWV0T3B0aW9ucz48eDpEaXNwbGF5R3JpZGxpbmVzLz48L3g6V29ya3NoZWV0T3B0aW9ucz48L3g6RXhjZWxXb3Jrc2hlZXQ+PC94OkV4Y2VsV29ya3NoZWV0cz48L3g6RXhjZWxXb3JrYm9vaz48L3htb..."
其中前面的 "data:application/vnd.ms-excel;base64,"是关键点；

` var tableToExcel = (function() {
var uri = 'data:application/vnd.ms-excel;base64,',
template = '

{table} ',
base64 = function(s) {
return window.btoa(unescape(encodeURIComponent(s)))
},

format = function(s, c) {
            return s.replace(/{(\w+)}/g,
                            function(m, p) {
                                return c[p];
                            }
            )
    };
    return function(table, name) {
        if (!table.nodeType) {
            table = document.getElementById(table)
        }
        
        var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML};
        
        
        window.location.href = uri + base64(format(template, ctx))
    }
})()`

2)IE：
` if(getExplorer()=='ie')
{
var curTbl = document.getElementById(tableid);
curTbl.style.border="1px";
curTbl.style.backgroundClip="padding-box";
curTbl.style.position="relative";
var oXL;
try
{
oXL = new ActiveXObject("Excel.Application");
}
catch(e)
{
alert("AlertMsg");
return;
}

var oWB = oXL.Workbooks.Add();
    var oSheet = oWB.ActiveSheet;  
    var Lenr = curTbl.rows.length;  
    for (i = 0; i < Lenr; i++)
    {        
        var Lenc = curTbl.rows(i).cells.length;
        for (j = 0; j < Lenc; j++)
        {  
             oSheet.Cells(i + 1, j + 1).value = curTbl.rows(i).cells(j).innerText;  
        }  
    }  
    oXL.Visible = true;
}`

3、判断浏览器函数
`function getExplorer() {
var explorer = window.navigator.userAgent ;

if (explorer.indexOf("MSIE") >= 0 ||  explorer.indexOf("Trident/7.0;") >= 0) {
    return 'ie';
}

else if (explorer.indexOf("Firefox") >= 0) {
    return 'Firefox';
}

else if(explorer.indexOf("Chrome") >= 0){
    return 'Chrome';
}

else if(explorer.indexOf("Opera") >= 0){
    return 'Opera';
}

else if(explorer.indexOf("Safari") >= 0){
    return 'Safari';
}

}`

4、性能测试：
3w条数据：ie导出非常慢(10分钟吧)；谷歌就直接崩了，页面跳转到about:blank#blocked；
1.5w条数据，谷歌导出时间还算理想，IE无问题就是慢