js导出格式化的excel 实例方法_javascript技巧

复制代码 代码如下:

function getTableDataByXML(inTable, 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 inTbl = tblDocument.getElementById(inTable);
    var outStr = "\n";
    outStr = outStr + "\n";
    outStr = outStr + "    outStr = outStr + " xmlns:o=\"urn:schemas-microsoft-com:office:office\"";
    outStr = outStr + " xmlns:x=\"urn:schemas-microsoft-com:office:excel\"";
    outStr = outStr + " xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\">\n";
    outStr = outStr + "\n";
    outStr = outStr + "\n";
    var re = /^[0-9]+.?[0-9]*$/; //是否为数字
    if (inTbl != null) {
        for (var j = 0; j             outStr += "\n";
            for (var i = 0; i                 if (i == 0 && rows > 0) {
                    outStr += "\n";
                    rows -= 1;
                }
                var cellValue = inTbl.rows[j].cells[i].innerText;
                //小于12位数字用Number
                if(re.test(cellValue) && (new String(cellValue)).length                     outStr = outStr + "" + cellValue + "\n";
                }else{
                    outStr = outStr + "" + cellValue + "\n";
                }
                if (inTbl.rows[j].cells[i].colSpan > 1) {
                    for (var k = 0; k                         outStr += " \n";
                    }
                }
                if (i == 0) {
                    if (rows == 0 && inTbl.rows[j].cells[i].rowSpan > 1) {
                        rows = inTbl.rows[j].cells[i].rowSpan - 1;
                    }
                }
            }
            outStr += "\n";
        }
    }
    else {
        outStr = null;
        alert("你要导出的表不存在！!");
        return;
    }
    outStr = outStr + "\n\n";
    return outStr;
}

上述函数原本是导出txt文件的函数。把excel文件另存为一个xml文件，就可得到excel能识别什么内容格式的xml文件。