• javascript 导出 有点遗憾是因为 这个导出会带出一个网页框 , 可以用


    function getXlsFromTbl(obj, title) {
        //var openPara = "left=" + (window.screen.width / 2 - width / 2) + ",top=" + (window.screen.height / 2 - height / 2) + ",scrollbars=no,width=" + width + ",height=" + height;
        var winname = window.open('', '_blank', 'height=100px,width=100px');
        var strHTML = document.getElementById(obj).innerHTML;
        winname.document.open('text/html', 'replace');
        winname.document.writeln(strHTML);
        var d = new Date();
        var curYear = d.getYear();
        var curMonth = "" + (d.getMonth() + 1);
        var curDate = "" + d.getDate();
        var curHour = "" + d.getHours();
        var curMinute = "" + d.getMinutes();
        var curSecond = "" + d.getSeconds();
        if (curMonth.length == 1) {
            curMonth = "0" + curMonth;
        }
        if (curDate.length == 1) {
            curDate = "0" + curDate;
        }
        if (curHour.length == 1) {
            curHour = "0" + curHour;
        }
        if (curMinute.length == 1) {
            curMinute = "0" + curMinute;
        }
        if (curSecond.length == 1) {
            curSecond = "0" + curSecond;
        }
        var fileName = title  + "_" + curYear + curMonth + curDate + curHour + curMinute + curSecond + ".xls";
    
        winname.document.execCommand('saveas', '', fileName);
        winname.close();
    }
    </script>

    onclick 调用;      //getXlsFromTbl('tableToEXC',$("#my_title_name").text());

    方法二  其实是同一个方法

        <SCRIPT LANGUAGE="javascript">
            function method1(tableid) {//整个表格拷贝到EXCEL中
                var curTbl = document.getElementById(tableid);
                var oXL = new ActiveXObject("Excel.Application");
                //创建AX对象excel
                var oWB = oXL.Workbooks.Add();
                //获取workbook对象
                var oSheet = oWB.ActiveSheet;
                //激活当前sheet
                var sel = document.body.createTextRange();
                sel.moveToElementText(curTbl);
                //把表格中的内容移到TextRange中
                sel.select();
                //全选TextRange中内容
                sel.execCommand("Copy");
                //复制TextRange中内容 
                oSheet.Paste();
                //粘贴到活动的EXCEL中      
                oXL.Visible = true;
                //设置excel可见属性
            }
            function method2(tableid) //读取表格中每个单元到EXCEL中
            {
                var curTbl = document.getElementById(tableid);
                var oXL = new ActiveXObject("Excel.Application");
                //创建AX对象excel
                var oWB = oXL.Workbooks.Add();
                //获取workbook对象
                var oSheet = oWB.ActiveSheet;
                //激活当前sheet
                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;
                //设置excel可见属性
            }
            function getXlsFromTbl(inTblId, inWindow) {
                try {
                    var allStr = "";
                    var curStr = "";
                    //alert("getXlsFromTbl");
                    if (inTblId != null && inTblId != "" && inTblId != "null") {
                        curStr = getTblData(inTblId, inWindow);
                    }
                    if (curStr != null) {
                        allStr += curStr;
                    }
                    else {
                        alert("你要导出的表不存在!");
                        return;
                    }
                    var fileName = getExcelFileName();
                    doFileExport(fileName, allStr);
                }
                catch (e) {
                    alert("导出发生异常:" + e.name + "->" + e.description + "!");
                }
            }
            function getTblData(inTbl, inWindow) {
                var rows = 0;
                //alert("getTblData is " + inWindow);
                var tblDocument = document;
                if (!!inWindow && inWindow != "") {
                    if (!document.all(inWindow)) {
                        return null;
                    }
                    else {
                        tblDocument = eval(inWindow).document;
                    }
                }
                var curTbl = tblDocument.getElementById(inTbl);
                var outStr = "";
                if (curTbl != null) {
                    for (var j = 0; j < curTbl.rows.length; j++) {
                        //alert("j is " + j);
                        for (var i = 0; i < curTbl.rows[j].cells.length; i++) {
                            //alert("i is " + i);
                            if (i == 0 && rows > 0) {
                                outStr += " \t";
                                rows -= 1;
                            }
                            outStr += curTbl.rows[j].cells[i].innerText + "\t";
                            if (curTbl.rows[j].cells[i].colSpan > 1) {
                                for (var k = 0; k < curTbl.rows[j].cells[i].colSpan - 1; k++) {
                                    outStr += " \t";
                                }
                            }
                            if (i == 0) {
                                if (rows == 0 && curTbl.rows[j].cells[i].rowSpan > 1) {
                                    rows = curTbl.rows[j].cells[i].rowSpan - 1;
                                }
                            }
                        }
                        outStr += "\r\n";
                    }
                }
                else {
                    outStr = null;
                    alert(inTbl + "不存在!");
                }
                return outStr;
            }
            function getExcelFileName() {
                var d = new Date();
                var curYear = d.getYear();
                var curMonth = "" + (d.getMonth() + 1);
                var curDate = "" + d.getDate();
                var curHour = "" + d.getHours();
                var curMinute = "" + d.getMinutes();
                var curSecond = "" + d.getSeconds();
                if (curMonth.length == 1) {
                    curMonth = "0" + curMonth;
                }
                if (curDate.length == 1) {
                    curDate = "0" + curDate;
                }
                if (curHour.length == 1) {
                    curHour = "0" + curHour;
                }
                if (curMinute.length == 1) {
                    curMinute = "0" + curMinute;
                }
                if (curSecond.length == 1) {
                    curSecond = "0" + curSecond;
                }
                var fileName = "leo_zhang" + "_" + curYear + curMonth + curDate + "_"
                + curHour + curMinute + curSecond + ".csv";
                //alert(fileName);
                return fileName;
            }
            function doFileExport(inName, inStr) {
                var xlsWin = null;
                if (!!document.all("glbHideFrm")) {
                    xlsWin = glbHideFrm;
                }
                else {
                    var width = 6;
                    var height = 4;
                    var openPara = "left=" + (window.screen.width / 2 - width / 2)
                    + ",top=" + (window.screen.height / 2 - height / 2)
                    + ",scrollbars=no,width=" + width + ",height=" + height;
                    xlsWin = window.open("", "_blank", openPara);
                }
                xlsWin.document.write(inStr);
                xlsWin.document.close();
                xlsWin.document.execCommand('Saveas', true, inName);
                xlsWin.close();
            }
    </SCRIPT>

    调用: onclick="javascript:getXlsFromTbl('tableExcel',null);"

  • 相关阅读:
    FlowNet2.0论文笔记
    LeetCode NO477.汉明距离总和
    自然语言的分词方法之N-gram语言模型
    C++函数模板及其实例化和具体化
    Vue2源码解读(5)
    Vue2源码解读(4)
    Vue2源码解读(3)
    Vue2源码解读(2)
    Vue2源码解读(1)
    vue的双向绑定原理及实现
  • 原文地址:https://www.cnblogs.com/TNSSTAR/p/2852902.html
Copyright © 2020-2023  润新知