Home  >  Article  >  Web Front-end  >  js export formatted excel instance method_javascript skills

js export formatted excel instance method_javascript skills

WBOY
WBOYOriginal
2016-05-16 17:28:451259browse
Copy code The code is as follows:

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 < inTbl.rows.length; j ) {
            outStr = "n";
            for (var i = 0; i < inTbl.rows[j].cells.length; 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 < 11){
                    outStr = outStr "" cellValue "n";
                }else{
                    outStr = outStr "" cellValue "n";
                }
                if (inTbl.rows[j].cells[i].colSpan > 1) {
                    for (var k = 0; k < inTbl.rows[j].cells[i].colSpan - 1; 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("The table you want to export does not exist!!");
return;
}
outStr = outStr "
n
n
";
return outStr;
}

The above function was originally a function to export txt files. Save the excel file as an xml file, and you can get the xml file in what content format excel can recognize.
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn