jsp 将表格以Excel形式导出方法之一（不用导包）

最新推荐文章于 2019-03-18 14:57:06 发布

别不说话

最新推荐文章于 2019-03-18 14:57:06 发布

阅读量800

点赞数 2

分类专栏：代码文章标签： excel myeclipse jsp

本文链接：https://blog.csdn.net/qq_28316183/article/details/78015890

版权

代码专栏收录该内容

29 篇文章 0 订阅

订阅专栏

1.使用这种方式可以将整个jsp页面以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 'Excel.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">
	-->

  </head>
  
  <body>

  <body>
     <%  
        String exportToExcel = request.getParameter("exportToExcel");  
        if (exportToExcel != null  
                && exportToExcel.toString().equalsIgnoreCase("YES")) {  
            response.setContentType("application/vnd.ms-excel");  
            response.setHeader("Content-Disposition", "inline; filename="  
                    + "excel.xls");  
   
        }  
    %>  <h1>这里是除表格以外的部分</h1>
    <table>  
    
        <thead>  
            <tr bgcolor="lightgreen">  
                <th>Sr. No.</th>  
                <th>Text Data</th>  
                <th>Number Data</th>  
            </tr>  
        </thead>  
        <tbody>  
            <%  
                for (int i = 0; i < 5; i++) {  
            %>  
            <tr bgcolor="lightblue">  
                <td align="center"><%=i + 1%></td>  
                <td align="center">This is text data <%=i%></td>  
                <td align="center"><%=i * i%></td>  
            </tr>  
            <%  
                }  
            %>  
        </tbody>  
    </table>  
    <br><br><br>
              
    <%  
        if (exportToExcel == null) {  
    %>  
    <a href="index.jsp?exportToExcel=YES">Export to Excel</a>  
    <%  
        }  
    %>  
  </body>
</html>

  </body>
</html>

效果图：

2.如果你只想导出表格而不是整个jsp页面，你可以用<jsp:include>的方法将表格包含进去

Excel.jsp

<%@ 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 'Excel.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">
	-->

  </head>
  
  <body>

  <body>
    <h1>这里是除表格以外的部分</h1>
    <jsp:include page="table.jsp"></jsp:include>
    <br><br><br><br>
      
    <a href="table.jsp">Export to Excel</a>  
    
    </body>
    </html>

table.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
	String wjm = "Excle.xls";
	response.setContentType("application/vnd.ms-excel;charset=utf-8");//当上一个页面点击跳转到这个页面，直接加载 导出
	response.setHeader("content-disposition", "attachment; filename="	+ wjm);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'table.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">
	-->

  </head>
  
  <body>
     <table align="left" border="2">  
        <thead>  
            <tr bgcolor="lightgreen">  
                <th>Sr. No.</th>  
                <th>Text Data</th>  
                <th>Number Data</th>  
            </tr>  
        </thead>  
        <tbody>  
            <%  
                for (int i = 0; i < 5; i++) {  
            %>  
            <tr bgcolor="lightblue">  
                <td align="center"><%=i + 1%></td>  
                <td align="center">This is text data <%=i%></td>  
                <td align="center"><%=i * i%></td>  
            </tr>  
            <%  
                }  
            %>  
        </tbody>  
    </table>  
  </body>
</html>

效果图：

注：还有一种经典的导出方式。可以去学习学习

别不说话

关注

2
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
jsp 将表格以Excel形式导出方法之一（不用导包）

1.使用这种方式可以将整个jsp页面以Excel的形式导出<%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%> ">
复制链接

扫一扫