| | |
| | | /* |
| | | * jQuery table2excel - v1.1.2 |
| | | * jQuery plugin to export an .xls file in browser from an HTML table |
| | | * https://github.com/rainabba/jquery-table2excel |
| | | * |
| | | * Made by rainabba |
| | | * Under MIT License |
| | | */ |
| | | |
| | | //table2excel.js |
| | | import jQuery from 'jquery' |
| | | (function ( $, window, document, undefined ) { |
| | | var pluginName = "table2excel", |
| | | |
| | | defaults = { |
| | | exclude: ".noExl", |
| | | name: "Table2Excel", |
| | |
| | | } |
| | | |
| | | // Create HTML for Row |
| | | tempRows += "<tr style='" + additionalStyles + "'>"; |
| | | tempRows += "<tr align='center' valign='center' style='" + additionalStyles + "'>"; |
| | | |
| | | // Loop through each TH and TD |
| | | $(p).find("td,th").not(e.settings.exclude).each(function (i,q) { // p did not exist, I corrected |
| | |
| | | if( rc.flag.length > 0 ) { |
| | | tempRows += "<td> </td>"; // exclude it!! |
| | | } else { |
| | | tempRows += "<td"; |
| | | // 匹配格式为'yyyy-mm'的日期字符串数据,若有其他需求后期再增加 |
| | | var regexPattern = /^\d{4}-\d{2}$/; |
| | | if($(q).html().match(regexPattern)){ |
| | | tempRows += "<td style=\"mso-number-format:'yyyy-mm';\""; |
| | | }else{ |
| | | tempRows += "<td"; |
| | | if(additionalStyles){ |
| | | tempRows += " style='" + additionalStyles + "'"; |
| | | } |
| | | } |
| | | if( rc.rows > 0) { |
| | | tempRows += " rowspan='" + rc.rows + "' "; |
| | | } |
| | | if( rc.cols > 0) { |
| | | tempRows += " colspan='" + rc.cols + "' "; |
| | | } |
| | | if(additionalStyles){ |
| | | tempRows += " style='" + additionalStyles + "'"; |
| | | } |
| | | tempRows += ">" + $(q).html() + "</td>"; |
| | | } |
| | |
| | | $.data( e, "plugin_" + pluginName, new Plugin( this, options ) ); |
| | | } |
| | | }); |
| | | |
| | | // chain jQuery functions |
| | | return e; |
| | | }; |