jq导出excal

最新推荐文章于 2023-08-18 10:38:29 发布
最新推荐文章于 2023-08-18 10:38:29 发布
阅读量171 收藏 1
点赞数
  1. <!DOCTYPE html>  
  2. <html lang="en">  
  3. <head>  
  4.     <meta charset="UTF-8">  
  5.   
  6. </head>  
  7. <body>  
  8.     <table border="0" cellspacing="0" cellpadding="0" id="datatable" class="xd_table_sj">  
  9.   
  10.                     <tbody>  
  11.                         <tr>  
  12.                             <td><div align="center" id="titlelable">起始时间</div></td>  
  13.                             <td><div align="center" id="titlelable">通信地点</div></td>  
  14.                             <td><div align="center" id="titlelable">上网方式</div></td>  
  15.                             <td><div align="center" id="titlelable">总时长</div></td>  
  16.                             <td><div align="center" id="titlelable">总流量</div></td>  
  17.                             <td><div align="center" id="titlelable">套餐优惠</div></td>  
  18.                             <td><div align="center" id="titlelable">优惠或减免</div></td>  
  19.                             <td><div align="center" id="titlelable">通信费</div></td>  
  20.                             <td><div align="center" id="titlelable">终端类型</div></td>  
  21.                         </tr>  
  22.                           
  23.                           
  24.                         <tr bgcolor="#EFFEDD" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#EFFEDD'" style="background: rgb(239, 254, 221);">  
  25.                                 <td>10-01 01:57:05</td>  
  26.                                 <td></td>  
  27.                                 <td>CMNET</td>  
  28.                                 <td>0秒</td>  
  29.                                 <td>0.001</td>  
  30.                                 <td>校园4G套餐-400M国内流量</td>  
  31.                                 <td></td>  
  32.                                 <td>0.00</td>  
  33.                                 <td></td>  
  34.                         </tr>  
  35.                           
  36.                         <tr bgcolor="#ffffff" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#ffffff'" style="background: rgb(255, 255, 255);">  
  37.                                 <td>10-01 01:58:55</td>  
  38.                                 <td></td>  
  39.                                 <td>CMNET</td>  
  40.                                 <td>0秒</td>  
  41.                                 <td>0.007</td>  
  42.                                 <td>校园4G套餐-400M国内流量</td>  
  43.                                 <td></td>  
  44.                                 <td>0.00</td>  
  45.                                 <td></td>  
  46.                         </tr>  
  47.                           
  48.                         <tr bgcolor="#EFFEDD" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#EFFEDD'" style="background: rgb(239, 254, 221);">  
  49.                                 <td>10-01 07:00:00</td>  
  50.                                 <td></td>  
  51.                                 <td>CMNET</td>  
  52.                                 <td>0秒</td>  
  53.                                 <td>0.001</td>  
  54.                                 <td>校园4G套餐-400M国内流量</td>  
  55.                                 <td></td>  
  56.                                 <td>0.00</td>  
  57.                                 <td></td>  
  58.                         </tr>  
  59.                           
  60.                         <tr bgcolor="#ffffff" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#ffffff'" style="background: rgb(255, 255, 255);">  
  61.                                 <td>10-01 07:23:19</td>  
  62.                                 <td></td>  
  63.                                 <td>CMNET</td>  
  64.                                 <td>0秒</td>  
  65.                                 <td>0.084</td>  
  66.                                 <td>校园4G套餐-400M国内流量</td>  
  67.                                 <td></td>  
  68.                                 <td>0.00</td>  
  69.                                 <td></td>  
  70.                         </tr>  
  71.                           
  72.                         <tr bgcolor="#EFFEDD" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#EFFEDD'" style="background: rgb(239, 254, 221);">  
  73.                                 <td>10-01 08:16:31</td>  
  74.                                 <td></td>  
  75.                                 <td>CMNET</td>  
  76.                                 <td>0秒</td>  
  77.                                 <td>0.001</td>  
  78.                                 <td>校园4G套餐-400M国内流量</td>  
  79.                                 <td></td>  
  80.                                 <td>0.00</td>  
  81.                                 <td></td>  
  82.                         </tr>  
  83.                           
  84.                         <tr bgcolor="#ffffff" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#ffffff'" style="background: rgb(255, 255, 255);">  
  85.                                 <td>10-01 08:16:39</td>  
  86.                                 <td></td>  
  87.                                 <td>CMNET</td>  
  88.                                 <td>0秒</td>  
  89.                                 <td>0.06</td>  
  90.                                 <td>校园4G套餐-400M国内流量</td>  
  91.                                 <td></td>  
  92.                                 <td>0.00</td>  
  93.                                 <td></td>  
  94.                         </tr>  
  95.                           
  96.                         <tr bgcolor="#EFFEDD" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#EFFEDD'" style="background: rgb(239, 254, 221);">  
  97.                                 <td>10-01 08:28:44</td>  
  98.                                 <td></td>  
  99.                                 <td>CMNET</td>  
  100.                                 <td>0秒</td>  
  101.                                 <td>0.002</td>  
  102.                                 <td>校园4G套餐-400M国内流量</td>  
  103.                                 <td></td>  
  104.                                 <td>0.00</td>  
  105.                                 <td></td>  
  106.                         </tr>  
  107.                           
  108.                         <tr bgcolor="#ffffff" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#ffffff'" style="background: rgb(255, 255, 255);">  
  109.                                 <td>10-01 08:34:50</td>  
  110.                                 <td></td>  
  111.                                 <td>CMNET</td>  
  112.                                 <td>0秒</td>  
  113.                                 <td>0.259</td>  
  114.                                 <td>校园4G套餐-400M国内流量</td>  
  115.                                 <td></td>  
  116.                                 <td>0.00</td>  
  117.                                 <td></td>  
  118.                         </tr>  
  119.                           
  120.                         <tr bgcolor="#EFFEDD" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#EFFEDD'" style="background: rgb(239, 254, 221);">  
  121.                                 <td>10-01 08:34:50</td>  
  122.                                 <td></td>  
  123.                                 <td>CMNET</td>  
  124.                                 <td>0秒</td>  
  125.                                 <td>1.26</td>  
  126.                                 <td>校园4G套餐-400M国内流量</td>  
  127.                                 <td></td>  
  128.                                 <td>0.00</td>  
  129.                                 <td></td>  
  130.                         </tr>  
  131.                           
  132.                         <tr bgcolor="#ffffff" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#ffffff'" style="background: rgb(255, 255, 255);">  
  133.                                 <td>10-01 09:54:53</td>  
  134.                                 <td></td>  
  135.                                 <td>CMNET</td>  
  136.                                 <td>0秒</td>  
  137.                                 <td>1.357</td>  
  138.                                 <td>校园4G套餐-400M国内流量</td>  
  139.                                 <td></td>  
  140.                                 <td>0.00</td>  
  141.                                 <td></td>  
  142.                         </tr>  
  143.                           
  144.                         <tr bgcolor="#EFFEDD" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#EFFEDD'" style="background: rgb(239, 254, 221);">  
  145.                                 <td>10-01 09:56:29</td>  
  146.                                 <td></td>  
  147.                                 <td>CMNET</td>  
  148.                                 <td>0秒</td>  
  149.                                 <td>0.003</td>  
  150.                                 <td>校园4G套餐-400M国内流量</td>  
  151.                                 <td></td>  
  152.                                 <td>0.00</td>  
  153.                                 <td></td>  
  154.                         </tr>  
  155.                           
  156.                         <tr bgcolor="#ffffff" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#ffffff'" style="background: rgb(255, 255, 255);">  
  157.                                 <td>10-01 09:56:31</td>  
  158.                                 <td></td>  
  159.                                 <td>CMNET</td>  
  160.                                 <td>0秒</td>  
  161.                                 <td>0.009</td>  
  162.                                 <td>校园4G套餐-400M国内流量</td>  
  163.                                 <td></td>  
  164.                                 <td>0.00</td>  
  165.                                 <td></td>  
  166.                         </tr>  
  167.                           
  168.                         <tr bgcolor="#EFFEDD" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#EFFEDD'" style="background: rgb(239, 254, 221);">  
  169.                                 <td>10-01 09:56:33</td>  
  170.                                 <td></td>  
  171.                                 <td>CMNET</td>  
  172.                                 <td>0秒</td>  
  173.                                 <td>0.583</td>  
  174.                                 <td>校园4G套餐-400M国内流量</td>  
  175.                                 <td></td>  
  176.                                 <td>0.00</td>  
  177.                                 <td></td>  
  178.                         </tr>  
  179.                           
  180.                         <tr bgcolor="#ffffff" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#ffffff'" style="background: rgb(255, 255, 255);">  
  181.                                 <td>10-01 10:27:16</td>  
  182.                                 <td></td>  
  183.                                 <td>CMNET</td>  
  184.                                 <td>0秒</td>  
  185.                                 <td>0.001</td>  
  186.                                 <td>校园4G套餐-400M国内流量</td>  
  187.                                 <td></td>  
  188.                                 <td>0.00</td>  
  189.                                 <td></td>  
  190.                         </tr>  
  191.                           
  192.                         <tr bgcolor="#EFFEDD" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#EFFEDD'" style="background: rgb(239, 254, 221);">  
  193.                                 <td>10-01 10:28:58</td>  
  194.                                 <td></td>  
  195.                                 <td>CMNET</td>  
  196.                                 <td>0秒</td>  
  197.                                 <td>0.004</td>  
  198.                                 <td>校园4G套餐-400M国内流量</td>  
  199.                                 <td></td>  
  200.                                 <td>0.00</td>  
  201.                                 <td></td>  
  202.                         </tr>  
  203.                           
  204.                         <tr bgcolor="#ffffff" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#ffffff'" style="background: rgb(255, 255, 255);">  
  205.                                 <td>10-01 12:44:12</td>  
  206.                                 <td></td>  
  207.                                 <td>CMNET</td>  
  208.                                 <td>0秒</td>  
  209.                                 <td>0.001</td>  
  210.                                 <td>校园4G套餐-400M国内流量</td>  
  211.                                 <td></td>  
  212.                                 <td>0.00</td>  
  213.                                 <td></td>  
  214.                         </tr>  
  215.                           
  216.                         <tr bgcolor="#EFFEDD" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#EFFEDD'" style="background: rgb(239, 254, 221);">  
  217.                                 <td>10-01 12:45:41</td>  
  218.                                 <td></td>  
  219.                                 <td>CMNET</td>  
  220.                                 <td>0秒</td>  
  221.                                 <td>0.411</td>  
  222.                                 <td>校园4G套餐-400M国内流量</td>  
  223.                                 <td></td>  
  224.                                 <td>0.00</td>  
  225.                                 <td></td>  
  226.                         </tr>  
  227.                           
  228.                         <tr bgcolor="#ffffff" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#ffffff'" style="background: rgb(255, 255, 255);">  
  229.                                 <td>10-01 12:57:42</td>  
  230.                                 <td></td>  
  231.                                 <td>CMNET</td>  
  232.                                 <td>0秒</td>  
  233.                                 <td>0.024</td>  
  234.                                 <td>校园4G套餐-400M国内流量</td>  
  235.                                 <td></td>  
  236.                                 <td>0.00</td>  
  237.                                 <td></td>  
  238.                         </tr>  
  239.                           
  240.                         <tr bgcolor="#EFFEDD" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#EFFEDD'" style="background: rgb(239, 254, 221);">  
  241.                                 <td>10-01 12:57:50</td>  
  242.                                 <td></td>  
  243.                                 <td>CMNET</td>  
  244.                                 <td>0秒</td>  
  245.                                 <td>0.009</td>  
  246.                                 <td>校园4G套餐-400M国内流量</td>  
  247.                                 <td></td>  
  248.                                 <td>0.00</td>  
  249.                                 <td></td>  
  250.                         </tr>  
  251.                           
  252.                         <tr bgcolor="#ffffff" onmouseover="this.style.background='#D2FCA0'" onmouseout="this.style.background='#ffffff'" style="background: rgb(255, 255, 255);">  
  253.                                 <td>10-01 12:57:52</td>  
  254.                                 <td></td>  
  255.                                 <td>CMNET</td>  
  256.                                 <td>0秒</td>  
  257.                                 <td>0.007</td>  
  258.                                 <td>校园4G套餐-400M国内流量</td>  
  259.                                 <td></td>  
  260.                                 <td>0.00</td>  
  261.                                 <td></td>  
  262.                         </tr>  
  263.                           
  264.                     </tbody>  
  265.                  </table>  
  266.     <button>导出EXCEL</button>  
  267.     <script src="js/jquery-3.2.1.js"></script>  
  268.   
  269.     <script src="js/jquery.table2excel.js"></script>  
  270.     <script>  
  271.         $('button').click(function(){  
  272.             console.log(1)  
  273.             $("#datatable").table2excel({  
  274.                 exclude: ".noExl",  
  275.                 name: "Excel Document Name",  
  276.                 filename: "myFileName",  
  277.                 exclude_img: true,  
  278.                 exclude_links: true,  
  279.                 exclude_inputs: true  
  280.             });  
  281.         })  
  282.     </script>  
  283. </body>  
  284. </html> 
qq_37109375
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
jq列表导出插件
02-28
这一款插件是改进网上已有jQuery.table2excel.js插件，使它支持不导出列，本着代码共享的原则，所以就免费分享给大家。
jq 导出功能
小史同学的博客
07-08 1106
$(document).on("click",".downLoad",function (e) { let id = $(this).data("fileid") let form = $("<form class='downloadForm'></form>"); // 设置属性 form.attr("action", serverU...
导出 jq导出(下载)Excel
weixin_54645059的博客
11-30 1232
表格中的数据导出或者下载到本地 <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0">
jq的文件导出代码（上传文件，导出文件）
热心市民小胖纸的博客
04-26 1000
function submitDataCompared() { var RootPath = getRootPath(); if ($('#dataCompared form').form('enableValidation').form('validate')) { var formData = new FormData($( "#hxfo...
jq导出文件及模板下载
miracle_mf的博客
09-09 348
DOM <div class="importDiv"> <!-- 页面展示部分，方便调整样式、按钮内容等 --> <input class="showInput" type="text" readonly="readonly" /> <button id="viewFileBtn">浏览</button> <!-- 真正起导入作用的是这个input，其展示样式有时不符合要求，故使用上面的展示 --> .
jquery 导出excel方法
11-14
下面将详细介绍jQuery导出Excel的方法，以及相关知识点。 1. **jQuery插件：TableExport** 文件`tableExport.jquery.plugin-a891806`可能是一个名为TableExport的jQuery插件，它允许开发者将HTML表格数据导出为...
jquery导出excel（解决中文导出）
06-08
网上下载的tableexport可以实现table的客户段导出功能，但由于所提供的base64无法实现中文导出，所以修改了base64编码，并修改了tableexport中使用base64部分，实现了对中文表格的导出功能
jquery导出excel
最新发布
02-28
// jquery导出表格excel $(table).table2excel({ exclude: ".noExl", // 可以将CSS类“noExl”添加到任何tr标记，以在导出时忽略指定的表数据 name: "Excel Document Name", filename: "xxx.xlsx", fileext: "....
jQuery直接导出Excel表格文件代码.zip
07-11
代码片段： <link rel="stylesheet" href="fonts/iconfont.css?3.1.64"> <link rel="stylesheet" href="css/font.css?3.1.64"> <link rel="stylesheet" href="css/style.css?...
利用js导出成excle表格
avery-leo
11-03 61
&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;&lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;&lt;head&gt;&lt;meta
Jquery导出表格
09-23
一个利用jquery导出excel表格的代码
jquery导出jqgrid表格
01-28
之前网上没找到现成的jqgrid表格前台导出插件，都或多或少带后台，也不想换表格插件，所以参照extjs自己改了个前台导出插件，支持多表头和分组table带表头导出，引用方法文件有详细注释，直接能用，如有不足还请见谅。
js 导出excel（支持大量数据）
11-02
前端导出数据为excel（兼容chrome 和 IE10以上版本），列举了网上常用的两种方法外，新增了可以导出超过5W行数据的方法
jquery表格table导出下载成
01-04
最近在整一个前端的一个测试工具，使用Express+Nodejs实现后台功能。为了能够实现前端表格的导出功能，各种尝试发现tableExport是一个很不错的插件。因此最后选择了hhurz的JQuery Plugin来实现表格的导出功能。 可以从下面的地址下载TableExport插件；该插件可以将Html的表格导出成为 JSON, XML, CSV, TSV, TXT, SQL, Word, Excel, PNG and PDF格式，支持的导出格式还是挺多的，基本能满足自己的需求。 因为github上作者给出的插件的使用描述已经很详细了，我就不在这里赘述很多重复的东西了（具体怎么使用该插件，还请麻烦移步tableExport的git上）。简述：我们可以通过下载插件，然后放到自己的工程路径下，使用’script’标签做路径引用能够很好实现Json、XML、CSV、TSV、TXT、SQL、Word、Excel格式的导出。
jq导出excel表格并下载保存
lixiaohua66的博客
08-23 2593
下载js ： <script src="plugins/tableExport.js"></script> <script src="plugins/base64.js"></script> 调用： $("#ar_table").tableExport({type:"excel",escape:"false"},fileName); fil...
jQuery表格导出Excel文件以及网页内容导出Word文档
热门推荐
Kobe Bryant
08-05 1万+
前言： 我在这里给大家介绍一下我们能用代码实现的最简单的两种转换为Excel文件以及Word文档的方法。 jQuery表格导出Excel文件 先来看看我们的层级划分： 如图所示： demo.css 代码如下： body, html { font-size: 100%; padding: 0; margin: 0;} /* Reset */ *, *:after, *:before { -w...
jquery中pdf的上传、下载及excel导出
joan_yb的博客
08-18 1410
jquery中pdf的上传、下载及excel导出
jquery4种导出excel方法(已测试)
weixin_30326741的博客
01-16 4495
第一种：（导出格式：csv、txt、excel、word、png） <!DOCTYPE html> <html lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>&l...
jquery把页面＜table＞里的内容导出为后缀名为.xlsx的excel
weixin_42032770的博客
11-18 3011
无论是sheetJS还是tableExport.js，导出成.xlsx后缀的excel文件都是不支持带边框线的，这个我查了文档没有找到相应的导出xlsx带边框线的demo，并且网上搜出来的凡是导出可以带边框线的excel都是导出为.xls后缀名的。这个如果有谁知道如何在前端把html导出成.xlsx后缀名的excel且可以设置边框线的，希望能够也告诉我一下。.csv、.xls、.xlsx的区别这三种后缀名是目前网页端导出excel的主流后缀名。
jq导出的excel表格 导出excel有下选框
11-01
通过jQuery技术，可以将页面上的表格导出为Excel文件。在导出时，可以解决纯数据导出后显示科学计数法和日期型导出后为#号显示的问题。需要注意的是，在前端的代码中，需要写出tbody的格式才能导出，而且tbody里边不...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值