JSP 导出EXCEL文件

最新推荐文章于 2024-03-13 20:13:10 发布

转载最新推荐文章于 2024-03-13 20:13:10 发布 · 534 阅读

本文介绍了如何通过JSP将页面设置为导出为Excel文件，并展示班级信息的实例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

把JSP里面的contentType设置为：

contentType="application/vnd.ms-excel; charset=UTF-8"

打开页面的时候就可以直接保存为一个EXCEL文件

代码示例

<%@ page language="java" contentType="application/vnd.ms-excel; charset=UTF-8"

    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" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<base href="<%=basePath%>">

<title>首页</title>

</head>

<body>

    <table class="table  table-condensed table-striped">

        <tr>

            <th>编号</th>

            <th>班级名称</th>

            <th>班级人数</th>

            <th>开班日期</th>

            <th>结束日期</th>

            <th>操作</th>

        </tr>

           <tr>

            <td>1001</td>

            <td>java一班</td>

              <td>30</td>

            <td>2014-12-12</td>

            <td>2015-12-12</td>

            <th>

            <a href="classinfo_update.html">修改</a> 

            <a href="">删除</a>

            </th>

        </tr>         <tr>

            <td>1001</td>

            <td>java一班</td>

              <td>30</td>

            <td>2014-12-12</td>

            <td>2015-12-12</td>

            <th>

            <a href="classinfo_update.html">修改</a> 

            <a href="">删除</a>

            </th>

        </tr>         <tr>

            <td>1001</td>

            <td>java一班</td>

              <td>30</td>

            <td>2014-12-12</td>

            <td>2015-12-12</td>

            <th>

            <a href="classinfo_update.html">修改</a> 

            <a href="">删除</a>

            </th>

        </tr>   

    </table>

</body>

</html>