• 非常简单的数据,支持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>

  • 相关阅读:
    帮人“解封微信”犯法?全国首例!判刑!
    热乎的校招面经试题解析——百度篇
    字节跳动入局在线教育:烧钱、亏钱
    TF-IDF 算法介绍
    Django ORM 常见查询条件
    Django中render和render_to_response的区别
    Python异步操作MongoDB --Motor的使用
    Java 如何抛出异常、自定义异常
    java项目中的classpath到底是什么
    maven里的modelVersion
  • 原文地址:https://www.cnblogs.com/zhangliang88/p/5470580.html
Copyright © 2020-2023  润新知