• 非常简单的数据,支持excel表格下载功能


    <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
    <%
    String path = request.getContextPath();
    String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
    %>

    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
    <head>
    <base href="<%=basePath%>">

    <title>My JSP 'MyJsp.jsp' starting page</title>

    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->
    <script type="text/javascript" src="oa/js/jquery-1.11.0.min.js"></script>
    <script type="text/javascript" src="oa/js/jquery.js"></script>
    <script type="text/javascript" src="oa/js/jquery.table2excel.min.js"></script>

    </HEAD>

    <BODY>
    <input type="button" id="btn" value="导出到excel">
    <table class="table2excel">
    <tr >
    <td>111<td>
    <td>222<td>
    <td >333<td>
    </tr>
    <tr>
    <td>444<td>
    <td>555<td>
    <td >666<td>
    </tr>
    </table>
    </BODY>
    <script>
    $(function() {
    var d = new Date();
    var date = d.getFullYear() + "年" +(d.getMonth() + 1) + "月" + d.getDate() + "日";
    $("#btn").click(function(){
    $(".table2excel").table2excel({
    exclude: ".noExl",
    name: "Excel Document Name",
    filename: date,
    exclude_img: true,
    exclude_links: true,
    exclude_inputs: true
    });
    });

    });
    </script>
    </HTML>

  • 相关阅读:
    如何节省 1TB 图片带宽?解密极致图像压缩
    微信亿级用户异常检测框架的设计与实践
    一文带你深度解析腾讯云直播答题方案
    kafka数据迁移实践
    揭密微信跳一跳小游戏那些外挂
    从蓝光到4K,腾讯视频高码率下载背后的技术
    GridControl列自动匹配宽度
    access的逻辑类型
    NPOI Excel类
    Access sql语句创建表及字段类型
  • 原文地址:https://www.cnblogs.com/zhangliang88/p/5470580.html
Copyright © 2020-2023  润新知