复制代码 代码如下:
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文件。
【js导出格式化的excel 实例方法】相关文章：