js导出格式化的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;

　　}