日期:2014-05-16  浏览次数:20420 次

js导出格式化的excel简单方法

1、最常见的方式是使用js函数操作excle文件,这种方式可能因浏览器不同,存在兼容性问题。

2、另一种简单方法就是导出一个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文件。