jsp

excel 다운

나웃기면백원 2012. 5. 7. 10:15

<%@  page language="java" contentType="application/vnd.ms-excel; text/html; charset=euc-kr"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix= "fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%
 response.setHeader("Content-Disposition", "attachment; filename=test_excel.xls");
 response.setHeader("Content-Description", "JSP Generated Data");
 response.setContentType("application/vnd.ms-excel");
%>

<jsp:scriptlet>pageContext.setAttribute("newline", "\n");</jsp:scriptlet>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>test_excel</title>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr" />
<style type="text/css">

.head{background-color: #F0E9D9}
/*
td{font-size:9pt; font-family:굴림;mso-number-format:"\@";mso-text-control:shrinktofit;white-space:nowrap;}
*/
td{text-align: center; font-size:9pt; font-family:굴림;mso-number-format:"\@";} 
br{mso-data-placement:same-cell;}

</style>

</head>
<body>

   <table border="1">
     <tr class="head">
      <th>순번</th>
       <th>일련번호</th>
       <th>연락처</th>
       <th>내용</th>
       <th>진행상태</th>
       <th>비고</th>
     </tr>
<c:forEach items="${ResultList }" var="item">
     <tr>
    <td style="width: 45px;">${item.RUM }</td>
       <td style="width: 75px;">${item.IDX }</td>
       <td style="width: 85px;">
        <c:out value="${fn:substring(item.REGIDATE, 0, 4)}" />-<c:out value="${fn:substring(item.REGIDATE, 4, 6)}" />-<c:out value="${fn:substring(item.REGIDATE, 6, 8)}" />
       </td>
       <td>${item.CONTACT }</td>
       <td style="text-align: left; padding-left: 5px;">${fn:replace(fn:escapeXml(item.CONTENT),newline ,'<br>') }</td>
       <td style="width: 70px;">
 <c:choose>
  <c:when test="${item.STATE eq '1' }">접수</c:when>
  <c:when test="${item.STATE eq '9' }">완료</c:when>
 </c:choose>
    </td>
       <td>${item.OTHER }</td>
     </tr>
</c:forEach>

  </table>

</body>
</html>