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

js export formatted excel instance method_javascript skills

WBOY
Release: 2016-05-16 17:28:45
Original
1284 people have browsed it
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.
Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template