源码网商城,靠谱的源码在线交易网站 我的订单 购物车 帮助

源码网商城

js导出格式化的excel 实例方法

  • 时间:2021-07-19 19:14 编辑: 来源: 阅读:
  • 扫一扫,手机访问
摘要:js导出格式化的excel 实例方法
[u]复制代码[/u] 代码如下:
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文件。
  • 全部评论(0)
联系客服
客服电话:
400-000-3129
微信版

扫一扫进微信版
返回顶部