jsp导出excel
通过request.setHeader的方式导出,在XP下运行没问题,但是放到生产环境unix下就有问题。报404,找不到页面,很费解。
JSP页面如下
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%><%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %><% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; // 清除缓存 response.setCharacterEncoding("UTF-8"); response.setHeader("Pragma", "no-cache"); response.setHeader("Cache-Control", "no-cache"); response.setDateHeader("Expires", 0); // 返回excel头 response.setHeader("Content-Type","application/force-download"); response.setContentType("application/vnd.ms-excel;"); response.addHeader("Content-Disposition", "attachment;filename=alarm");%><table border="1" cellpadding="0" cellspacing="0"> <tr style="background-color: #cccccc;"> <th>描述</th> <th>发生时间</th> </tr> <c:forEach var="al" items="${alList}"> <tr> <td>${al.alDesc}</td> <td>${al.occurTimeStr}</td> </tr> </c:forEach> </table>