前端实现页面数据导出功能（兼容ie）

最新推荐文章于 2024-04-24 16:44:38 发布

爱笑的刚刚

最新推荐文章于 2024-04-24 16:44:38 发布

阅读量603

点赞数 1

分类专栏： javascript

本文链接：https://blog.youkuaiyun.com/xuewengang/article/details/107559504

版权

javascript 专栏收录该内容

3 篇文章

订阅专栏

				let excel = ''
                // 生成表头
                let row =   '<tr>' +
                            '<td>区域</td>' +
                            '<td>数量</td>' +
                            '</tr>';
                excel += row;
                excel += '<tr>';
                excel += '<td>sss</td>';
                excel += '<td>'+msg.total+'个</td>';
                excel +='</tr>';
                excel += '</table>';
               if(!!window.ActiveXObject || "ActiveXObject" in window){
               		//ie浏览器导出
                    var curTbl = document.getElementById('table1');
                    var oXL = new ActiveXObject("Excel.Application");
                    var oWB = oXL.Workbooks.Add();
                    var oSheet = oWB.ActiveSheet;
                    var sel = document.body.createTextRange();
                    sel.moveToElementText(curTbl);
                    sel.select();
                    sel.execCommand("Copy");
                    oSheet.Paste();
                    oXL.Visible = true;
               }else{
               		//其他浏览器导出
                    //下载的表格模板数据
                    var excelFile = '<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">';
                    excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">';
                    excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel"';
                    excelFile += ' charset="UTF-8">';
                    excelFile += '<head>';
                    excelFile += '<!--[if gte mso 9]>';
                    excelFile += '<xml>';
                    excelFile += '<x:ExcelWorkbook>';
                    excelFile += '<x:ExcelWorksheets>';
                    excelFile += '<x:ExcelWorksheet>';
                    excelFile += '<x:Name>';
                    excelFile += 'sheet';
                    excelFile += '</x:Name>';
                    excelFile += '<x:WorksheetOptions>';
                    excelFile += '<x:DisplayGridlines/>';
                    excelFile += '</x:WorksheetOptions>';
                    excelFile += '</x:ExcelWorksheet>';
                    excelFile += '</x:ExcelWorksheets>';
                    excelFile += '</x:ExcelWorkbook>';
                    excelFile += '</xml>';
                    excelFile += '<![endif]-->';
                    excelFile += '</head>';
                    excelFile += '<body>';
                    excelFile += excel;
                    excelFile += '</body>';
                    excelFile += '</html>';
                    //下载模板
                    let uri = 'data:application/vnd.ms-excelcharset=utf-8,' + encodeURIComponent(excelFile);
                    let link = document.createElement('a');
                    link.href = uri;
                    link.style = 'visibility:hidden';
                    let myDate = new Date();
                    let time = myDate.toLocaleDateString().split('/').join('-');
                    link.download = '名称' + time + '.xls';

                    document.body.appendChild(link);
                    link.click();
                    document.body.removeChild(link);
               }