JSP 导出Excel表格的实例

response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition","attachment;filename=" + URLEncoder.encode("会员列表.xls", "UTF-8"));

%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
%
 response.setContentType("application/vnd.ms-excel");
 response.setHeader("Content-disposition","attachment;filename=" + java.net.URLEncoder.encode("会员列表.xls", "UTF-8"));
%>
!DOCTYPE html>
html>
head>
 title>CMS-会员管理/title>
 meta charset="utf-8" />
 meta http-equiv="pragma" content="no-cache"/>
 meta http-equiv="cache-control" content="no-cache"/>
 meta http-equiv="expires" content="0"/>
/head>
body>

table id="sample-table-1" border="1" cellpadding="2" cellspacing="1">
 thead>
 tr>
  th nowrap width="15%">序号/th>
  th nowrap width="5%">卡号/th>
  th nowrap width="5%">姓名/th>
  th nowrap width="5%">年龄/th>

 /tr>
 /thead>
 tbody>
 c:forEach items="${list}" var="model" varStatus="status" >
  tr>
   td>${model.id}/td>
   td>${model.cardNo}/td>
   td>${model.name}/td>
   td>${model.age}/td>
  /tr>
 /c:forEach>
 /tbody>
/table>
/body>
/html>