使ç¨table2excelè¡¨æ ¼æ件éè¦å¨é¡µé¢ä¸å¼å
¥jqueryåjquery.table2excel.jsæ件ã
<script type="text/javascript" src="js/jquery.min.js"></script>
<script type="text/javascript" src="js/jquery.table2excel.js"></script>
HTMLç»æ
ä½ å¯ä»¥å°ä»»ä½æ åçHTMLè¡¨æ ¼ç»æçæ°æ®å¯¼åºå°Excelä¸ï¼ä¸ä¸ªHTMLè¡¨æ ¼çç»æ为ï¼
<table>
<thead>
<tr class="noExl">
<td>带<code>noExl</code>classçè¡ä¸ä¼è¢«è¾åºå°excelä¸</td>
<td>带<code>noExl</code>classçè¡ä¸ä¼è¢«è¾åºå°excelä¸</td>
</tr>
<tr>
<td>è¿ä¸è¡ä¼è¢«å¯¼åºå°excelä¸</td>
<td>è¿ä¸è¡ä¼è¢«å¯¼åºå°excelä¸</td>
</tr>
</thead>
<tbody>
<tr>
<td>åå
æ ¼1-1</td>
<td>åå
æ ¼1-2</td>
</tr>
<tr>
<td>åå
æ ¼2-1</td>
<td>åå
æ ¼2-2</td>
</tr>
<tr>
<td>åå
æ ¼3-1</td>
<td>åå
æ ¼3-2</td>
</tr>
</tbody>
<tfoot>
<tr>
<td colspan="2">å并2个åå
æ ¼</td>
</tr>
</tfoot>
</table>
å¦æè¡¨æ ¼ä¸çæä¸è¡ä¸éè¦å¯¼åºå°Excelä¸ï¼å¯ä»¥ä¸ºè¿ä¸è¡æ·»å .noExl classç±»ï¼è¯¥classç±»ä¼å¨æ件åå§åæ¶éè¿åæ°è¢«æå®ä¸ºä¸è¢«å¯¼åºçæ°æ®ã
åå§åæ件
å¨é¡µé¢DOMå
ç´ å è½½ä¸å®æ¯ä¹åï¼å¯ä»¥éè¿ä¸é¢çæ¹æ³æ¥åå§åtable2excelæ件ã
$("#table2excel").table2excel({
// ä¸è¢«å¯¼åºçè¡¨æ ¼è¡çCSS classç±»
exclude: ".noExl",
// 导åºçExcelææ¡£çå称
name: "Excel Document Name",
// Excelæ件çå称
filename: "myExcelTable"
});
é
ç½®åæ°
table2excelæ件çå¯ç¨é
ç½®åæ°æï¼
excludeï¼ä¸è¢«å¯¼åºçè¡¨æ ¼è¡çCSS classç±»ã
nameï¼å¯¼åºçExcelææ¡£çå称ã
filenameï¼Excelæ件çå称ã
exclude_imgï¼æ¯å¦å¯¼åºå¾çã
exclude_linksï¼æ¯å¦å¯¼åºè¶
é¾æ¥
exclude_inputsï¼æ¯å¦å¯¼åºè¾å
¥æ¡ä¸çå
容ã
温馨提示:答案为网友推荐,仅供参考