jsp 导出Excel 没有表格！在线等.....

y_0715 2011-08-10 06:27:51

导出后Excel没有框？？求解！

<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
<html xmlns="http://www.w3.org/1999/xhtml">
<%@ include file="/jsp/templates/resource.jsp"%>
<%@ page contentType="application/msexcel"%>
<%
request.setCharacterEncoding("gb2312");
response.setCharacterEncoding("gb2312");
//attachment 下载 inline打开
request.getAttribute("");

response.setHeader("Content-Disposition", "attachment; filename="
+ java.net.URLEncoder.encode(request.getAttribute("crName")+"演奏会.xls", "UTF-8"));
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
%>

<html>

<head>
<TITLE>演奏会今本信息</TITLE>

</HEAD>
<BODY>

<br>
<br>
<br>
<table class="table_bg" align="center" id="idData" style="width: 100%;">
<tr>
<th>编号</th>
<th>学期</th>
<th>年级</th>
<th>班级</th>
<th>专业</th>
<th>演奏者</th>
<th>演奏会名称</th>
<th>演奏会地址</th>
<th>演奏会相关曲目</th>
<th>演奏会开始时间</th>
<th>演奏会结束时间</th>
</tr>
<c:forEach items="${concertConcertregistrations}" var="list" varStatus="i">
<tr align="center">
<td>${i.index+1}<input type="hidden" name="crId" id="crId" value="${ list.crId }" /></td>
<td>
<c:forEach items="${schoolClasseList }" var="classe">
<c:if test="${classe.scNo==list.schoolClasses.scNo }">
${classe.schoolGrade.schoolSemester.semesterName }
</c:if>
</c:forEach>
<%-- ${list.schoolClasses.schoolGrade.schoolSemester.semesterName } --%>
</td>
<td>
<c:forEach items="${schoolClasseList }" var="classe">
<c:if test="${classe.scNo==list.schoolClasses.scNo }">
${classe.schoolGrade.sgName }
</c:if>
</c:forEach>
<%-- ${list.schoolClasses.schoolGrade.sgName } --%>
</td>
<td>
<c:forEach items="${schoolClasseList }" var="classe">
<c:if test="${classe.scNo==list.schoolClasses.scNo }">
${classe.scName }
</c:if>
</c:forEach>

</td>
<td>
${list.academicDiscipline.adName}
</td>
<td>
<span title="${list.crUserName }">
<c:choose>
<c:when test="${fn:length(list.crUserName) > 10}">
<c:out value="${fn:substring(list.crUserName, 0, 10)}......" />
</c:when>
<c:otherwise>
<c:out value="${list.crUserName}" />
</c:otherwise>
</c:choose></span>
</td>
<td>
${list.crName }
</td>
<td>
<span title="${list.crAddress }">
<c:choose>
<c:when test="${fn:length(list.crAddress) > 10}">
<c:out value="${fn:substring(list.crAddress, 0, 10)}......" />
</c:when>
<c:otherwise>
<c:out value="${list.crAddress}" />
</c:otherwise>
</c:choose></span> </td>
<td>
<span title="${list.crRepertoire }">
<c:choose>
<c:when test="${fn:length(list.crRepertoire) > 10}">
<c:out value="${fn:substring(list.crRepertoire, 0, 10)}......" />
</c:when>
<c:otherwise>
<c:out value="${list.crRepertoire}" />
</c:otherwise>
</c:choose>
</span>
</td>
<td><fmt:formatDate value="${list.crStartDate}" pattern="yyyy-MM-dd "/> </td>
<td><fmt:formatDate value="${list.crEndDate}" pattern="yyyy-MM-dd "/> </td>
</tr>

</c:forEach>
</table>
</BODY>
</HTML>

...全文