在action(此处用的是SpringMVC)中:
// 列表
@RequestMapping("/...")
public String ryxxlb(Object condition, Model model, HttpServletResponse response) {
List<Object> list = getList(condition);//按条件获取想要的数据
model.addAttribute("list", list);
response.setContentType("application/msexcel; charset=utf-8");//设置Excel类型
response.setHeader("Content-disposition", "inline; filename=personInfo.xls");//以文件形式下载同时指定文件名称
return "excel.jsp";
}
jsp页面
<?xml version="1.0" encoding="utf-8" ?>
<%@ page language="java"
contentType="application/msexcel; charset=utf-8" pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<style>
table, th, td {
border: black solid 0.5px;
text-align: center;
}
</style>
</head>
<body>
<table>
<thead>
<tr>
<th>head1</th>
<th>head2</th>
<th>head3</th>
</tr>
</thead>
<tbody>
<c:forEach var="item" items="${list}">
<tr>
<td>${item.field}</td>
<td>${item.field}</td>
<td>${item.field}</td>
</tr>
</c:forEach>
</tbody>
</table>
</body>
</html>