萬盛學電腦網

 萬盛學電腦網 >> 腳本專題 >> javascript >> js導出格式化的excel 實例方法

js導出格式化的excel 實例方法

最常見的方式是使用js函數操作excle文件,這種方式可能因浏覽器不同,存在兼容性問題。另一種簡單方法就是導出一個excel能識別格式的xml文件,用excel打開。   復制代碼 代碼如下:
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 = "<?xml version="1.0"?>n";
    outStr = outStr + "<?mso-application progid="Excel.Sheet"?>n";
    outStr = outStr + "<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"";
    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 + "<Worksheet ss:Name="Sheet1">n";
    outStr = outStr + "<Table ss:ExpandedColumnCount="30">n";
    var re = /^[0-9]+.?[0-9]*$/; //是否為數字
    if (inTbl != null) {
        for (var j = 0; j < inTbl.rows.length; j++) {
            outStr += "<Row ss:AutoFitHeight="0">n";
            for (var i = 0; i < inTbl.rows[j].cells.length; i++) {
                if (i == 0 && rows > 0) {
                    outStr += "<Cell><Data ss:Type="String"></Data></Cell>n";
                    rows -= 1;
                }
                var cellValue = inTbl.rows[j].cells[i].innerText;
                //小於12位數字用Number
                if(re.test(cellValue) && (new String(cellValue)).length < 11){
                    outStr = outStr + "<Cell><Data ss:Type="Number">" + cellValue + "</Data></Cell>n";
                }else{
                    outStr = outStr + "<Cell><Data ss:Type="String">" + cellValue + "</Data></Cell>n";
                }
                if (inTbl.rows[j].cells[i].colSpan > 1) {
                    for (var k = 0; k < inTbl.rows[j].cells[i].colSpan - 1; k++) {
                        outStr += " <Cell><Data ss:Type="String"></Data></Cell>n";
                    }
                }
                if (i == 0) {
                    if (rows == 0 && inTbl.rows[j].cells[i].rowSpan > 1) {
                        rows = inTbl.rows[j].cells[i].rowSpan - 1;
                    }
                }
            }
            outStr += "</Row>n";
        }
    }
    else {
        outStr = null;
        alert("你要導出的表不存在!!");
        return;
    }
    outStr = outStr + "</Table>n</Worksheet>n</Workbook>";
    return outStr;
}


上述函數原本是導出txt文件的函數。把excel文件另存為一個xml文件,就可得到excel能識別什麼內容格式的xml文件。

copyright © 萬盛學電腦網 all rights reserved