js导出table兼容IE浏览器

最新推荐文章于 2023-05-18 14:39:13 发布

mlc19860417

最新推荐文章于 2023-05-18 14:39:13 发布

阅读量767

点赞数

分类专栏： js

本文链接：https://blog.csdn.net/mlc19860417/article/details/89553629

版权

js 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

引入jquery.js

引入jquery.table2excel.js

jquery.table2excel代码:

页面代码:

引入jquery.js

引入jquery.table2excel.js

jquery.table2excel代码:

/*
* jQuery table2excel - v1.0.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
;(function ( $, window, document, undefined ) {
var pluginName = "table2excel",

   defaults = {
       exclude: ".noExl",
           name: "Table2Excel"
   };

   // The actual plugin constructor
   function Plugin ( element, options ) {
           this.element = element;
           // jQuery has an extend method which merges the contents of two or
           // more objects, storing the result in the first object. The first object
           // is generally empty as we don't want to alter the default options for
           // future instances of the plugin
           //
           this.settings = $.extend( {}, defaults, options );
           this._defaults = defaults;
           this._name = pluginName;
           this.init();
   }

   Plugin.prototype = {
       init: function () {
           var e = this;

e.template = {
               head: "<html xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\"><head><meta charset=\"UTF-8\"></head><body>",
               table: {
                   head: "<table>",
                   tail: "</table>"
               },
               foot: "</body></html>

页面代码:

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
<style>
table td {
font-size: 12px;
width: 200px;
height: 30px;
text-align: center;
background-color: #4f891e;
color: #ffffff;
}
</style>
<script type="text/javascript" src="jquery-1.4.2.min.js"></script>

</head>
<body>
<table cellspacing="0" cellpadding="0" border="1" id="tableToExcel" class="tableToExcel">
<thead>
<tr>
<td >公司一</td>
<td>公司二一</td>
<td>公司三</td>
</tr>
</thead>
<tbody>
<tr>
<td>A公司</td>
<td>B公司</td>
<td>C公司</td>
</tr>
<tr>
<td>A公司</td>
<td>B公司</td>
<td>C公司</td>
</tr>
<tr>
<td>A公司</td>
<td>B公司</td>
<td>C公司</td>
</tr>
<tr>
<td colspan="3">共计</td>
</tr>
</tbody>
</table>
<button type="button" id="btnExport" >导出Excel</button>
<script>
$("#btnExport").click(function(){
$("#tableToExcel").table2excel({
exclude: ".noExl",
name: "统计",
filename: "入库统计",
exclude_img: true,
exclude_links: true,
exclude_inputs: true
});
});
</script>
</body>
</html>

mlc19860417

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
js导出table兼容IE浏览器

目录引入jquery.js引入jquery.table2excel.jsjquery.table2excel代码:页面代码:引入jquery.js引入jquery.table2excel.jsjquery.table2excel代码:/** jQuery table2excel - v1.0.2* jQuery plugin to export a...
复制链接

扫一扫

专栏目录